SYS_DBC_ENTRIES

Information on all databases which are known to the DBH.

Column name	Data type	Contents
DBC_NUMBER	SMALLINT	DBC ID number
CATALOG_NAME	CHAR (18)	Logical database name
PHYSICAL_NAME	CHAR (18)	Physical database name
USER_ID	CHAR (8)	DB user ID of the database
COPY_NUMBER	CHAR (6)	Version number of the SESAM backup copy of the catalog space, if the database is a SESAM backup copy.
ACCESS_MODE	VARCHAR (5)	Current access mode: READ Permits read access to user data and metadata. WRITE Permits read and write access to user data. Metadata may not be changed. ADMIN Permits read and update access to user data and metadata. REPL A replication is involved. This replication can be accessed in read mode. COPY Permits read access to user data and metadata. The utility statement COPY is permitted.
STATUS	VARCHAR (7)	Database status: ACTIVE The database was opened in the current DBH session. CLOSED The database is closed. FREE The database is physically closed and unlocked. LOCKED Because of an SQLSTATE the database is not available in the current DBH session. RECOVER The database is in the state RECOVER. REORG The database is reorganized. REFRESH The database is in the state REFRESH.
STATUS_INFO	VARCHAR(21)	Information on why the database is not available (only when STATUS = LOCKED).
STATUS_TIME	TIMESTAMP(3)	Time the current status was determined

Table 113: SYS_DBC_ENTRIES view of the INFORMATION_SCHEMA