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 when a redistribute database partition group operation has completed
successfully.
- 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.
|