SYSDATABASE catalog table

The SYSDATABASE table contains one row for each database. The schema is SYSIBM.

Table 1. SYSIBM.SYSDATABASE table column descriptions
Column name Data type Description Use
NAME
VARCHAR(24)
NOT NULL
 Database name. G
CREATOR
VARCHAR(128)
NOT NULL
 Authorization ID of the owner of the database. G
STGROUP
VARCHAR(128)
NOT NULL
 Name of the default storage group of the database; blank for a system database. G
BPOOL
CHAR(8)
NOT NULL
 Name of the default buffer pool of the table space; blank for a system table space. G
DBID
SMALLINT
NOT NULL
 Internal identifier of the database. If there were 32511 databases or more when this database was created, the DBID is a negative number. S
IBMREQD
CHAR(1)
NOT NULL
 A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators.

The value in this field is not a reliable indicator of release dependencies. RELCREATED should be used instead.

 G
CREATEDBY
VARCHAR(128)
NOT NULL WITH
DEFAULT
 Primary authorization ID of the user who created the database. G
ROSHARE
CHAR(1)
NOT NULL WITH
DEFAULT
 Not used. N
TIMESTAMP
TIMESTAMP
NOT NULL WITH
DEFAULT
 Not used. N
TYPE
CHAR(1)
NOT NULL WITH
DEFAULT
 Type of database:
blank
Not a work file database or a TEMP database.
T
A TEMP file database.
W
A work file database. The database is DSNDB07, or it was created with the WORKFILE clause and used as a work file database by a member of a Db2 data sharing group.
 G
GROUP_MEMBER
VARCHAR(24)
NOT NULL WITH
DEFAULT
 The Db2 data sharing member name of the Db2 subsystem that uses this work file database. This column is blank if the work file database was not created in a Db2 data sharing environment, or if the database is not a work file database as indicated by the TYPE column. G
CREATEDTS
TIMESTAMP
NOT NULL WITH
DEFAULT
 Time when the CREATE statement was executed for the database. For DSNDB04 and DSNDB06, the value is '1985-04-01.00.00.00.000000'. G
ALTEREDTS
TIMESTAMP
NOT NULL WITH
DEFAULT
 Time when the most recent ALTER DATABASE statement was applied. If no ALTER DATABASE statement has been applied, ALTEREDTS has the value of CREATEDTS. G
ENCODING_SCHEME
CHAR(1)
NOT NULL WITH
DEFAULT 'E'
 Default encoding scheme for the database:
E
EBCDIC
A
ASCII
U
Unicode
blank
For DSNDB04, a work file database, and a TEMP database.
 G
SBCS_CCSID
INTEGER
NOT NULL WITH
DEFAULT
 Default SBCS CCSID for the database. For a TEMP database, a work file database, or a database created in a Db2 release prior to Version 5, the value is 0. G
DBCS_CCSID
INTEGER
NOT NULL WITH
DEFAULT
 Default DBCS CCSID for the database. If mixed data is not used and the CCSID for the database is defined as EBCDIC or ASCII, the default value is 0.

For a TEMP database, a work file database, or a database created in a Db2 release prior to Version 5, the value is 0.

 G
MIXED_CCSID
INTEGER
NOT NULL WITH
DEFAULT
 Default mixed CCSID for the database. If mixed data is not used and the CCSID for the database is defined as EBCDIC or ASCII, the default value is 0.

For a TEMP database, a work file database, or a database created in a Db2 release prior to Version 5, the value is 0.

 G
INDEXBP
CHAR(8)
NOT NULL WITH
DEFAULT 'BP0'
 Name of the default buffer pool for indexes. G
IMPLICIT
CHAR(1)
NOT NULL WITH
DEFAULT 'N'
 Indicates whether the database was implicitly created:
Y
The database was implicitly created
N
The database was explicitly created
 G
CREATORTYPE
CHAR(1)
NOT NULL WITH
DEFAULT
 Indicates the type of creator:
blank
Authorization ID
L
Role
 G
RELCREATED
CHAR(1)
NOT NULL
 The release of Db2 that is used to create the object. See Release dependency indicators for the values. G