DB2 10.5 for Linux, UNIX, and Windows

LIST DBPARTITIONNUMS command

Lists all database partitions or members associated with the current database.

Scope

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.

Authorization

None

Required connection

Database

Command syntax


>>-LIST DBPARTITIONNUMS----------------------------------------><

Command parameters

None

Examples

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.