SYSCATALOGS

The SYSCATALOGS view contains one row for each relational database that a user can connect to. The following table describes the columns in the SYSCATALOGS view.

Table 1. SYSCATALOGS view
Column Name System Column Name Data Type Description
CATALOG_NAME LOCATION VARCHAR(18) Relational database name.
CATALOG_STATUS RDBASPSTAT CHAR(10) Status of a relational database.
ACTIVE
The relational database is associated with an independent auxiliary storage pool (IASP) that is active, but not yet available.
AVAILABLE
The relational database is available.
VARYOFF
The relational database is associated with an independent auxiliary storage pool (IASP) that is varied off.
VARYON
The relational database is associated with an independent auxiliary storage pool (IASP) that is varied on, but not yet available.
UNKNOWN
The status of the relational database is unknown. The status of remote relational databases is always unknown.
CATALOG_TYPE RDBTYPE CHAR(7) Relational database type.
LOCAL
The relational database is local to this system.
REMOTE
The relational database is on a remote system.
CATALOG_ASPGRP RDBASPGRP VARCHAR(10)

Nullable

Independent auxiliary storage pool (IASP) name.

Contains the null value if the relational database status is UNKNOWN.

CATALOG_ASPNUM RDBASPNUM VARCHAR(10)

Nullable

Independent auxiliary storage pool (IASP) number.

Contains the null value if the relational database status is UNKNOWN.

CATALOG_TEXT RDBTEXT Start of changeVARGRAPHIC(50) CCSID 1200

Nullable

End of change
Relational database text description.