How to find the nodes of a partitioned database?

[Venkat G]

As we know ,we can add a partition to instance without adding it to the database by editing the "db2nodes.c fg" when the instance is down and bringing up the instance. At this point the new partition is only added to the instance and it is not added to the databases in the instance.

My Question:
How to find the current nodes of a partitioned database?

[victor deng]

I will look into the syscat views:
select "DBPARTITIONNUM ", "TYPE", "PATH"
from "SYSIBMADM"."DB PATHS" where type='DBPATH';

[Venkat G]

select "DBPARTITIONNUM ", "TYPE", "PATH"
from "SYSIBMADM"."DB PATHS" where type='DBPATH';

The above command works fine if database is already created on all the nodes defined in db2nodes.cfg. But it gives the following error if database doesnot belong to any of the nodes in db2nodes.cfg.

SQL1031N The database directory cannot be found on the indicated file system.
SQLSTATE=58031

[Venkat G]

$db2 list dbpartitionnums

The above command should work fine, it lists all the db partitions in the the output.