DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.DBPARTITIONGROUPS catalog view

Each row represents a database partition group.

Table 1. SYSCAT.DBPARTITIONGROUPS Catalog View
Column Name Data Type Nullable Description
DBPGNAME VARCHAR (128)   Name of the database partition group.
OWNER VARCHAR (128)   Authorization ID of the owner of the database partition group.
OWNERTYPE CHAR (1)  
  • S = The owner is the system
  • U = The owner is an individual user
PMAP_ID SMALLINT   Identifier for the distribution map in the SYSCAT.PARTITIONMAPS catalog view.
REDISTRIBUTE_PMAP_ID SMALLINT   Identifier for the distribution map currently being used for redistribution; -1 if redistribution is currently not in progress.
CREATE_TIME TIMESTAMP   Creation time of the database partition group.
DEFINER1 VARCHAR (128)   Authorization ID of the owner of the database partition group.
REMARKS VARCHAR (254) Y User-provided comments, or the null value.
Note:
  1. The DEFINER column is included for backwards compatibility. See OWNER.