LIST DBPARTITIONNUMS command

The 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

Read syntax diagramSkip visual syntax diagramLIST 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.