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
1200Nullable ![]() |
Relational database text description. |