cancel
Showing results for 
Search instead for 
Did you mean: 

Do not see Partitions

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member189725
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Thanks apparently there were some issues with partitions and the DB team fixed it.

Answers (0)