DB2 Version 9.7 for Linux, UNIX, and Windows

LIST DBPARTITIONNUMS command

Lists all database partitions associated with the current database.

Scope

This command can be issued from any database partition that is listed in $HOME/sqllib/db2nodes.cfg. It returns the same information from any of these database partitions.

Authorization

None

Required connection

Database

Command syntax


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

Command parameters

None

Examples

Following is sample output from the LIST DBPARTITIONNUMS command:

DATABASE PARTITION NUMBER
-------------------------
                        0
                        2
                        5
                        7
                        9

     5 record(s) selected.

Compatibilities

For compatibility with versions earlier than Version 8:

The keyword NODES can be substituted for DBPARTITIONNUMS.