on 07-22-2012 7:30 AM
All
I am coming from an Oracle env to DB2. In SAP transaction DB02 I do not see all the partitions of the DB2 database although the size of the database itself is dispalyed right taking into account all partition.
The only partition that is visible is partition 0 (zero).
Thanks
svaraj
Is the system SAP BW ?
Also in the OS level check the file db2nodes.cfg under /db2/db2<sid>/sqllib
Do you see multiple entries in the file ?
Also login as db2<sid>
execute
db2 LIST DBPARTITIONNUMS
How many partitions do you see ?
In DB2 , you can have databases with multiple partitions or a single partition . For single partition database the only partition is zero.
Regards
Ratnajit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.