Table information record (DTBI)
The logical log contains one instance of the Table Information Record for each table that has change information represented in this logical log.
This record type contains information describing a Db2 table.
Record status: Db2 specific
Field name | Offset | Definition | Description | |
|---|---|---|---|---|
Dec | Hex | |||
CNTLRECORDTYPE | 00 | 00 | CHAR(4) | Control record type: DTBI - Table Information Record |
SYSID | 04 | 04 | CHAR(4) | Originating SYSID |
DBID | 08 | 08 | CHAR(4) | Originating database ID (hexadecimal) |
PSID | 12 | 0C | CHAR(4) | Originating table space ID (hexadecimal) |
TBOBID | 16 | 10 | CHAR(4) | Originating table ID (hexadecimal) |
OBJECTTYPE | 20 | 14 | CHAR(2) | Type of object TB - table |
DB2NUMCOL | 22 | 16 | CHAR(3) | Number of columns in originating table |
DB2MAXROWLEN | 25 | 19 | CHAR(5) | Maximum row length (in Db2 internal format) |
LLNUMCOL | 30 | 1E | CHAR(3) | Number of columns in logical log data record |
LLMAXROWLEN | 33 | 21 | CHAR(5) | Maximum row length of data in logical log record |
ROWTYPE | 38 | 26 | CHAR(1) | V - varying F - fixed length |
SEQUENCENUMBER | 39 | 27 | 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 (DIXI, DCXI, DCLI, DLCI). |
CREATERBA | 42 | 2A | BIN(10) 1 | Create RBA/LRSN of this instance of the table |
54 | 34 | BIN(2) | Reserved | |
DROPRBA | 54 | 36 | BIN(10) 1 | Drop RBA/LRSN of this instance of the table |
64 | 40 | BIN(2) | Reserved | |
ENCODINGSCHEME | 66 | 42 | CHAR(1) | A - ASCII E - EBCDIC U - Unicode |
EDITPROCNAMELEN | 67 | 43 | CHAR(3) | Length of the edit proc name (zero if none) |
EDITPROCNAME | 70 | 46 | CHAR(24) | Name of edit proc for this table (blanks if none) |
DBNAMELEN | 94 | 5E | CHAR(3) | Length of the database name |
DBNAME | 97 | 61 | CHAR(24) | Database name to which this table belongs |
TSNAMELEN | 121 | 79 | CHAR(3) | Length of the table space name |
TSNAME | 124 | 7C | CHAR(24) | Table space name to which this table belongs |
TABLEOWNERLEN | 148 | 94 | CHAR(3) | Length of the owner portion of the table name |
TABLEOWNER | 151 | 97 | CHAR(128) | Originating table owner name |
SHORTOWNER | 279 | 117 | CHAR(8) | Truncated version of the table owner name (The first eight bytes of the table owner name. This name version is included in records in the logical log data file.) |
TABLENAMELEN | 287 | 11F | CHAR(3) | Length of table name |
TABLENAME | 290 | 122 | CHAR(128) | Table name |
SHORTNAME | 418 | 1A2 | CHAR(18) | Shortened version of the table name (This version is included in records in the logical log data file. |
VERSION | 436 | 1B4 | CHAR(3) | Version number of the table (when the logical log file was generated) |
UNTRANOWNERFLAG | 439 | 1B7 | CHAR(1) | Y - untranslatable characters in table owner N - no untranslatable characters present |
UNITABLEOWNERLEN | 440 | 1B8 | CHAR(3) | Length of original Unicode table owner |
UNITABLEOWNER | 443 | 1BB | CHAR(128) | Original Unicode table owner name |
UNTRANNAMEFLAG | 571 | 23B | CHAR(1) | Y - untranslatable characters in table name N - no untranslatable characters present |
UNITABLENAMELEN | 572 | 23C | CHAR(3) | Length of original Unicode table name |
UNITABLENAME | 575 | 23F | CHAR(128) | Original Unicode table name |
LOBSINCLUDED | 703 | 2BF | CHAR(1) | Y - LOBs included in output files N - LOBs excluded from output files |
XMLINCLUDED | 704 | 2C0 | CHAR(1) | Y - XML included in output files N - XML excluded from output files |
(Total Length) | 704 | 2C0 | Not applicable | Not applicable |
1 BIN(10) LRSN is extended format LRSN.
Non-extended format LRSN, BIN(6) is placed at offset 1 (for example, X'CA670FBBF3D3' -> X'00CA670FBBF3D3000000').
BIN(10) RBA is extended format RBA.
Non-extended format RBA, BIN(6) is placed at offset 4 (for example, X'123456789ABC' -> X'00000000123456789ABC').
Related topic