Home > IT Answers > AS/400 > AS400 – Logical parititioning
iiiiiiiiiiiii
335 pts.
 AS400 – Logical parititioning
AS/400 LPAR, LPAR
Hi Folks I have small question on LPAR's,how we do LPAR on AS400. Mainly i want to do paritioning on my database whcih is db2 database.Can anyone help me on this. Thanks in advance

Software/Hardware used:
AS400
ASKED: February 16, 2012  7:04 AM
UPDATED: March 17, 2012  4:46 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question. Michael Tidmarsh   11,400 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

An LPAR is an second instance of the entire system and it is not a small question.
LPAR is not equilvant to Oracle Partitions. DB2/400 does not need database partitions.
Phil

philpl1jb
 44,180 pts.
 

Database partitioning is done through the (5761SS1 option 27 for i 6.1) DB2 Multisystem option. If you do not have that option installed, you will need to order and install it.

As Phil noted, LPARs and database partitions are very different. In many ways, they are not related.

Tom

TomLiotta
 108,055 pts.
 

I don’t think the multisystem option is anything like Oracle Partitions. In fact AS/400 file members come closer to Oracle Partitions but not very close.

philpl1jb
 44,180 pts.
 

In fact AS/400 file members come closer to Oracle Partitions…

DB2 Multisystem implements database partitions through a form of database file members.

But how did Oracle come into this question?

Tom

TomLiotta
 108,055 pts.
 

describe the issues and the version of the operating system.

philpl1jb
 44,180 pts.
 

I insertred it becasue that’s been a recurring question
and made more sense then LPAR

philpl1jb
 44,180 pts.