Directory table spaces and indexes
Db2 directory tables are contained in certain table spaces and have indexes.
The following table lists the table space and indexes for each directory table and lists the index fields for each index. The indexes are in ascending order.
The directory table space, tables, and indexes are primarily intended for use by Db2 and are therefore subject to change.
| TABLE SPACE
DSNDB01. … |
TABLE
SYSIBM. … |
INDEX
SYSIBM. … |
INDEX FIELDS |
|---|---|---|---|
| DBD01 | DBDR | DSNDB01X | DBID.SECTION |
| SYSDBDXA | SYSDBD_DATA | DSNDB1XA | DBD_DATA |
| SCT02 | SCTR | DSNSCT02 | SCTNAME.SCTSEC.
SPTSEQ |
| SPT01 | SPTR | DSNSPT01 | SPTPID.SPTSEC.
SPTSEQ |
| DSNSPT02 | version.SPTID.
SPTSEC.SPTSEQ |
||
| SYSSPUXA | SYSSPTSEC_DATA | DSNSPDXA | SPTSEC_DATA |
| SYSSPUXB | SYSSPTSEC_EXPL | DSNSPEXA | SPTSEC_EXPL |
| SYSLGRNX | SYSLGRNX | DSNLLX01 | LGRDBID.LGRPSID.
LGRPART.LGRMEMB. LGRSLRSN |
| DSNLLX02 | LGRDBID.LGRPSID.
LGRSLRSN |
||
| SYSUTILX | SYSUTIL | DSNLUX01 | USUUID |
| SYSUTILX | DSNLUX02 | UTILID.SEQNO
|