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 is required:
- sysadm
- sysctrl
- sysmaint
- sysmon
- dbadm
- CONTROL privilege
- SELECT privilege.
Required connection
Database
Command syntax
>>-LIST DATABASE PARTITION GROUPS--+-------------+-------------><
'-SHOW DETAIL-'
Command parameters
- SHOW DETAIL
- Specifies that the output should include the following information:
- Distribution map ID
- Database partition number
- In-use flag
Examples
Following is sample output from
the
LIST DATABASE PARTITION GROUPS command:
DATABASE PARTITION GROUP NAME
-----------------------------
IBMCATGROUP
IBMDEFAULTGROUP
2 record(s) selected.
Following 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.
Compatibilities
For compatibility with
versions earlier than Version 8:
- The keyword NODEGROUPS can be substituted for DATABASE
PARTITION GROUPS.