SYSAUXRELS catalog table
The SYSAUXRELS table contains one row for each auxiliary table created for a LOB column. A base table space that is partitioned must have one auxiliary table for each partition of each LOB column. The schema is SYSIBM.
| Column name | Data type | Description | Use |
|---|---|---|---|
| TBOWNER | VARCHAR(128)
NOT NULL |
The schema of the base table. | G |
| TBNAME | VARCHAR(128)
NOT NULL |
Name of the base table. | G |
| COLNAME | VARCHAR(128)
NOT NULL |
Name of the LOB column in the base table. | G |
| PARTITION | SMALLINT
NOT NULL |
Partition number if the base table space is partitioned. Otherwise, the value is 0. | G |
| AUXTBOWNER | VARCHAR(128)
NOT NULL |
The schema of the auxiliary table. | G |
| AUXTBNAME | VARCHAR(128)
NOT NULL |
Name of the auxiliary table. | G |
| AUXRELOBID | INTEGER
NOT NULL |
Internal identifier of the relationship between the base table and the auxiliary table. | 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 |
| RELCREATED | CHAR(1)
NOT NULL |
The release of Db2 that is used to create the object. Blank if created prior to Version 9. See Release dependency indicators for all other values. | G |