Clustering index information record (DCXI)
Record status: Db2 specific
Field name | Offset | Definition | Description | |
|---|---|---|---|---|
Dec | Hex | |||
CNTLRECORDTYPE | 00 | 00 | CHAR(4) | Control record type: DCXI - Clustering Index Information Record |
SYSID | 04 | 04 | CHAR(4) | Originating SYSID |
DBID | 08 | 08 | CHAR(4) | Originating DBID (hexadecimal) |
PSID | 12 | 0C | CHAR(4) | Originating index PSID (hexadecimal) |
TBOBID | 16 | 10 | CHAR(4) | Originating Table ID (hexadecimal) |
NUMCOLSINKEY | 20 | 14 | CHAR(3) | Number of columns in the index key |
SEQUENCENUMBER | 23 | 17 | CHAR(3) | Sequence number to distinguish multiple versions of the same database object. The default value is 001. This sequence number is equal to the sequence number in the other records associated with the definition of this table (DTBI, DIXI). |
TYPE | 26 | 1A | CHAR(1) | Index type from SYSIBM.SYSINDEXES |
IXCREATORLEN | 27 | 1B | CHAR(3) | Length of the index creator name |
IXCREATOR | 30 | 1E | CHAR(128) | Originating index creator name |
IXNAMELEN | 158 | 9E | CHAR(3) | Length of the index name |
IXNAME | 161 | A1 | CHAR(128) | Originating index name |
(Total Length) | 289 | 121 | Not applicable | Not applicable |