Table information record (DTBI)
Related topics
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 the originating table |
DB2MAXROWLEN | 25 | 19 | CHAR(5) | Maximum row length (in Db2 internal format) |
LLNUMCOL | 30 | 1E | CHAR(3) | Number of columns in the logical log data record |
LLMAXROWLEN | 33 | 21 | CHAR(5) | Maximum row length of data in a 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) | The 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) | The 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 the 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 the 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 an extended format RBA.
Non-extended format RBA, BIN(6) is placed at offset 4 (for example, X'123456789ABC' -> X'00000000123456789ABC').