Index column description record (DICL)
The logical log contains at least one Index Column Description Record for each Index Description Record in the logical log control file.
Additional records are used if there are more than 15 key columns. This record type contains mapping information for the columns that are part of the associated index. A single Index Column Description record can describe up to 14 columns of an index. The maximum number of columns for a Db2 index currently is 64.
Record status: Db2 specific
Field name | Offset | Definition | Description | |||
|---|---|---|---|---|---|---|
Dec | Hex | |||||
CNTLRECORDTYPE | 00 | 00 | CHAR(4) | Control record type: DICL - Index Description Record | ||
SYSID | 04 | 04 | CHAR(4) | Originating SYSID | ||
DBID | 08 | 08 | CHAR(4) | Originating DBID (hex) | ||
PSID | 12 | 0C | CHAR(4) | Originating Index PSID (hex) | ||
IXCOLRECNUM | 16 | 10 | CHAR(2) | Record Number of this DICL record (01-05) | ||
IXCOLRECKEYCOUNT | 18 | 12 | CHAR(2) | Number of entries of columns mapped on this DICL record | ||
SEQUENCENUMBER | 20 | 14 | CHAR(3) | Sequence number to distinguish multiple versions of the same database object. The default value is 001. | ||
DICLKEYINFO | 23 | 17 | VARIABLE | IXCOLRECKEYCOUNT entries of the following layout: | ||
KEYCOL | CHAR(3) | Column Number | ||||
KEYCOLORDER | CHAR(1) | A - ascending D - descending | ||||
Related topic