DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.DBPARTITIONGROUPDEF catalog view

Each row represents a database partition that is contained in a database partition group.

Table 1. SYSCAT.DBPARTITIONGROUPDEF Catalog View
Column Name Data Type Nullable Description
DBPGNAME VARCHAR (128)   Name of the database partition group that contains the database partition.
DBPARTITIONNUM SMALLINT   Partition number of a database partition that is contained in the database partition group. A valid partition number is between 0 and 999, inclusive.
IN_USE CHAR (1)   Status of the database partition.
  • A = The newly added database partition is not in the distribution map, but the containers for the table spaces in the database partition group have been created; the database partition is added to the distribution map once the REDISTRIBUTION is in progress.
  • D = The database partition will be dropped when a redistribute database partition group operation has completed successfully.
  • T = The newly added database partition is not in the distribution map, and it was added using the WITHOUT TABLESPACES clause; containers must be added to the table spaces in the database partition group.
  • Y = The database partition is in the distribution map.