LIST DATABASE PARTITION GROUPS command

The LIST DATABASE PARTITION GROUPS command lists all database partition groups 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

For the system catalogs SYSCAT.DBPARTITIONGROUPS and SYSCAT.DBPARTITIONGROUPDEF, one of the following authorities is required:

SYSADM
SYSCTRL
SYSMAINT
SYSMON
DBADM
SELECTIN privilege on the SYSCAT schema
CONTROL privilege
SELECT privilege.

Required connection

Database

Command syntax

Command parameters

SHOW DETAIL

Specifies that the output should include the following information:

Distribution map ID
Database partition number
In-use flag

Examples

The following example is sample output from the LIST DATABASE PARTITION GROUPS command:

DATABASE PARTITION GROUP NAME
-----------------------------
IBMCATGROUP                 
IBMDEFAULTGROUP             

  2 record(s) selected.

The following example is sample output from the LIST DATABASE PARTITION GROUPS SHOW DETAIL command:

DATABASE PARTITION GROUP NAME  PMAP_ID DATABASE PARTITION NUMBER IN_USE
------------------------------ ------- ------------------------- ------
IBMCATGROUP                          0                         0 Y     
IBMDEFAULTGROUP                      1                         0 Y     

  2 record(s) selected.

The fields are identified as follows:

DATABASE PARTITION GROUP NAME

The name of the database partition group. The name is repeated for each database partition in the database partition group.

PMAP_ID

The ID of the distribution map. The ID is repeated for each database partition in the database partition group.

DATABASE PARTITION NUMBER

The number of the database partition.

IN_USE

One of four values:

Y: The database partition is being used by the database partition group.
D: The database partition is going to be dropped from the database partition group as a result of a REDISTRIBUTE DATABASE PARTITION GROUP operation. When the operation completes, the database partition will not be included in reports from LIST DATABASE PARTITION GROUPS.
A: The database partition has been added to the database partition group but is not yet added to the distribution map. The containers for the table spaces in the database partition group have been added on this database partition. The value is changed to Y when the REDISTRIBUTE DATABASE PARTITION GROUP operation completes successfully.
T: The database partition has been added to the database partition group, but is not yet added to the distribution map. The containers for the table spaces in the database partition group have not been added on this database partition. Table space containers must be added on the new database partition for each table space in the database partition group. The value is changed to A when containers have successfully been added.