Logical log column information record (DLCI)
The logical log contains one instance of the Logical Log Column Information Record for every column actually created in a logical log data change record for one of the tables selected.
This record contains information about the location and format of a column as it exists in the logical log data change record. It also contains information about how this column fits into the index key selected for this table.
Record status: Db2 specific
Field name | Offset | Definition | Description | |
|---|---|---|---|---|
Dec | Hex | |||
CNTLRECORDTYPE | 00 | 00 | CHAR(4) | Control record type: DLCI - Logical Log Column Information Record (Db2) |
SYSID | 04 | 04 | CHAR(4) | Originating SYSID |
DBID | 08 | 08 | CHAR(4) | Originating database ID (hexadecimal) |
TBOBID | 12 | 0C | CHAR(4) | Originating table ID (hexadecimal) |
LLCOLUMNNUM | 16 | 10 | CHAR(3) | Column number |
LLCOLUMNTYPE | 19 | 13 | CHAR(4) | Column data type in the logical log CHAR - character DEC - packed decimal INT - integer (length is 2 or 4) DTTM - timestamp value FLOT - floating point (length is 4 or 8) VCHR - variable length character GRPH - graphic VGRF - variable length graphic DATE - date (length is 10) TIME - time (length is 8) LVCH - long variable character LVGR - long variable graphic BLOB - binary large object CLOB - character large object DBCL - double-byte character large object ROWI - row ID DTTZ - timestamp with time zone |
LLCOLUMNLEN | 23 | 17 | CHAR(5) | Length of the column in the logical log file |
LLSCALE | 28 | 1C | CHAR(2) | Column scale for decimal data |
LLNULLS | 30 | 1E | CHAR(1) | Y - nulls allowed N - not null L - nullable large object (LOB) |
LLCOLUMNPOS | 31 | 1F | CHAR(5) | If the logical log data record does not contain a VARCHAR column, this value represents: Offset of the current column within the DATA field of the logical log data record. If the current column’s position in the logical log data record is before the first VARCHAR column (or the current column is the first VARCHAR column), this value represents: Offset of the current column within the DATA field of the logical log data record. If the current column’s position in the logical log data records is after the first VARCHAR column, the product sets this value to -1. |
LLCOLUMNSUBTYPE | 36 | 24 | CHAR(1) | If LLCOLUMNTYPE is CHAR or VCHR: B - for bit data S - single-byte character set M - mixed-byte character set I - inline LOB If DB2COLUMNTYPE is BIGINT: D - DOCID column (XML columns) All other LLCOLUMNTYPE values: ' ' - not valued |
KEYSEQ | 37 | 25 | CHAR(3) | Key for SQL generation/ reporting by key |
KEYORDERING | 40 | 28 | CHAR(1) | A - ascending D - descending |
DB2ROWBYTES | 41 | 29 | CHAR(5) | Number of bytes on a Db2 row (encoded/internalized) |
FLDPROCBYTES | 46 | 2E | CHAR(5) | Number of bytes after field proc (decoded/externalized) |
LOGLOGBYTES | 51 | 33 | CHAR(5) | Number of bytes on a logical log record |
SEQUENCENUMBER | 56 | 38 | 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 Table Information Record (DTBI) of this table. |
COLUMNNAMELEN | 59 | 3B | CHAR(3) | Length of the column name |
COLUMNNAME | 62 | 3E | CHAR(128) | Column name |
VERSION | 190 | B4 | CHAR(3) | Version number of the table containing the column (when the logical log file was generated) |
(Total Length) | 193 | C1 | Not applicable | Not applicable |
Related topic