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 1. Table spaces and indexes for the directory tables
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