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.
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.
|
CATALOG_TYPE | RDBTYPE | CHAR(7) | Relational database type.
|
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 | VARGRAPHIC(50) CCSID
1200 Nullable
|
Relational database text description. |