Description: 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.
Tablespace: SYSOBJ
Indexes(Fields):
DSNOXX01(TBOWNER.TBNAME)
DSNOXX02(AUXTBOWNER.AUXTBNAME)
| Column name | Description | Data type |
|---|---|---|
| TBOWNER | Authorization ID of the owner of the base table. | NOT NULL |
| TBNAME | Name of the base table. | NOT NULL |
| COLNAME | Name of the LOB column in the base table. | NOT NULL |
| PARTITION | Partition number if the base table space is partitioned. Otherwise, the value is 0. | NOT NULL |
| AUXTBOWNER | Authorization ID of the owner of the auxiliary table. | NOT NULL |
| AUXTBNAME | Name of the auxiliary table. | NOT NULL |
| AUXRELOBID | Internal identifier of the relationship between the base table and the auxiliary table. | NOT NULL |
| IBMREQD | A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. | NOT NULL |
Adapted from material found in the IBM DB2 Universal Database for z/OS V8 SQL Reference (SC18-7426-02).