LOB column description record (DLOB)
Related topics
Record status: Db2 specific
Field name | Offset | Definition | Description | |
|---|---|---|---|---|
Bytes (dec) | Bytes (hex) | |||
CNTLRECORDTYPE | 0 | 0X0 | CHAR(4) | Control record type: DLOB - LOB Column Description Record (Db2) |
NOLOGGING | 4 | 0X4 | CHAR(1) | Y - Logging is disabled for the current LOB table space N - Logging is enabled for the current LOB table space |
NULLCOL | 5 | 0X5 | CHAR(1) | Y - LOB is nullable N - LOB is not nullable |
DBNAME | 6 | 0X6 | CHAR(8) | Name of database that contains auxiliary LOB table space |
TSNAME | 14 | 0XE | CHAR(8) | Name of auxiliary LOB table space |
BASETSNAME | 22 | 0X16 | CHAR(8) | Name of base table space that contains current LOB column |
NPART | 30 | 0X1E | CHAR(5) | Number of partitions in the base table that contains current LOB columns |
DSNUM | 35 | 0X23 | CHAR(5) | Total number of LOB VSAM files created for a current LOB column |
PGSIZE | 40 | 0X28 | CHAR(10) | The page size of LOB VSAM files created for the current LOB column (4K, 8K, 16K, and so forth) |
DSSIZE | 50 | 0X32 | CHAR(10) | Maximum size (in kilobytes) of LOB VSAM files created for a current LOB column |
DBID | 60 | 0X3C | CHAR(4) | Database identifier (DBID) of database that contains auxiliary LOB table |
PSID | 64 | 0X40 | CHAR(4) | Page set identifier (PSID) of LOB table space that contains an auxiliary table |
OBID | 68 | 0X44 | CHAR(4) | An object identifier (OBID) of auxiliary LOB table |
BASEDBID | 72 | 0X48 | CHAR(4) | Database identifier (DBID) of database that contains a base table with current LOB column |
BASEPSID | 76 | 0X4C | CHAR(4) | Page set identifier (PSID) of table space that contains a base table with current LOB column |
BASEOBID | 80 | 0X50 | CHAR(4) | An object identifier (OBID) of the base table with LOB column |
TBCREATOR | 84 | 0X54 | CHAR(128) | Creator of an auxiliary LOB table |
TBNAME | 212 | 0XD4 | CHAR(128) | Name of an auxiliary LOB table |
COLNAME | 340 | 0X154 | CHAR(128) | Name of current LOB column in base and auxiliary tables |
BASETBNAME | 468 | 0X1D4 | CHAR(128) | Name of the base table with current LOB column |
BASETBCREATOR | 596 | 0X254 | CHAR(128) | Creator of the base table with current LOB column |
NUMROLLS | 724 | 0X2D4 | CHAR(10) | Number of rollback actions that affect current LOB column |
NUMMAPRECS | 734 | 0X2DE | CHAR(10) | Number of LOB map records encountered for a current LOB column |
NUMDATARECS | 744 | 0X2E8 | CHAR(10) | Number of LOB data records encountered for a current LOB column |
NUMMAPPAGES | 754 | 0X2F2 | CHAR(10) | Number of pages within LOB map records encountered for a current LOB column |
NUMDATAPAGES | 764 | 0X2F2 | CHAR(10) | Number of pages within LOB data records encountered for a current LOB column |
NUMUPDATES | 774 | 0X306 | CHAR(10) | Number of updates to a current LOB column |
NUMINSERTS | 784 | 0X310 | CHAR(10) | Number of inserts to a current LOB column |
NUMDELETES | 794 | 0X31A | CHAR(10) | Number of deletes to a current LOB column |
CREATERBA | 804 | 0X324 | BIN(10) 1 | Relative byte address (RBA) when auxiliary LOB table was created |
| 814 | 0X32E | BIN(2) | Reserved |
ALTERRBA | 816 | 0X330 | BIN(10) 1 | RBA when auxiliary LOB table was altered |
| 826 | 0X33A | BIN(2) | Reserved |
DROPPEDRBA | 828 | 0X33C | BIN(10) 1 | RBA when auxiliary LOB table was dropped |
| 838 | 0X346 | BIN(2) | Reserved |
CREATETIMESTAMP | 840 | 0X348 | BIN(17) 1 | Db2 timestamp value when auxiliary LOB table was created |
| 857 | 0X359 | BIN(3) | Reserved |
ALTERTIMESTAMP | 860 | 0X35C | BIN(17) 1 | Timestamp when auxiliary LOB table was altered |
| 877 | 0X36D | BIN(3) | Reserved |
DROPPEDTIMESTAMP | 880 | 0X370 | BIN(17) 1 | Timestamp when auxiliary LOB table was dropped |
| 897 | 0X381 | BIN(3) | Reserved |
TABCONCREATERBA | 900 | 0X384 | BIN(10) 1 | RBA when the base table that contains current LOB column was created |
| 910 | 0X38E | BIN(2) | Reserved |
OTSEQNUM | 912 | 0X390 | CHAR(3) | Overtime sequence number (if applicable) |
MAXCOLLENGTH | 915 | 0X393 | CHAR(10) | Maximum column length |
INLINELENGTH | 925 | 0X39D | CHAR(10) | Inline column length |
INLINELOB | 935 | 0X3A7 | CHAR(1) | Y - The LOB is defined as INLINE N - The LOB is not defined as INLINE |
| 936 | 0X3A8 | CHAR(1) | Reserved |
LOGGINGWASON | 937 | 0X3A9 | CHAR(1) | Y - Logging was on N - Logging was not on |
LOGGINGWASOFF | 938 | 0X3AA | CHAR(1) | Y - Logging was off N - Logging was not off |
| 939 | 0X3AB | CHAR(1) | Reserved |
| 940 | 0X3AC | CHAR(10) | Reserved |
(Total Length) | 950 | 0X3B6 | Not applicable | Not applicable |
1 BIN(17) timestamps are of the format X'YYYYMMDDHHMMSSHHMMMMNNNPPPFFF00000' where:
- YYYYMMDD is the date given as year, month, day
- HHMMSS is the time given as hour, minute, seconds
- HHMMMMNNNPPPFFF00000 represents fractional seconds and padding
BIN(10) LRSN is an 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').