Lists all database partitions or members associated with the current database.
This command can be issued from any database partition or member that is listed in $HOME/sqllib/db2nodes.cfg. It returns the same information from any of these database partitions or members.
None
Database
None
Example 1 - Partitioned database instance : Following is sample output from the LIST DBPARTITIONNUMS command:
DATABASE PARTITION NUMBER
-------------------------
0
2
5
7
9
5 record(s) selected.
Example 2 - DB2® pureScale® instance : In a DB2 pureScale environment, LIST DBPARTITIONNUMS will always report a single partition.
DATABASE PARTITION NUMBER
-------------------------
0
1 record(s) selected.