XML column description record (DXML)
The logical log contains one XML Column Description Record for each XML column that occurs in selected log records and for which the product creates at least one XML VSAM file to contain data from an XML column.
Record status: Db2 specific
Field name | Offset | Definition | Description | |
|---|---|---|---|---|
Bytes (dec) | Bytes (hex) | |||
CNTLRECORDTYPE | 0 | 0X0 | CHAR(4) | Control record type: DXML - XML Column Description Record (Db2) |
NOLOGGING | 4 | 0X4 | CHAR(1) | Y - Logging disabled for current XML table space N - Logging enabled for current XML table space |
NULLCOL | 5 | 0X5 | CHAR(1) | Y - XML is nullable N - XML is not nullable |
DBNAME | 6 | 0X6 | CHAR(8) | Name of database that contains XML table space |
TSNAME | 14 | 0XE | CHAR(8) | Name of XML table space |
BASETSNAME | 22 | 0X16 | CHAR(8) | Name of table space that contains current XML column |
NPART | 30 | 0X1E | CHAR(5) | Number of partitions in the table that contains current XML columns |
DSNUM | 35 | 0X23 | CHAR(5) | Total number of XML VSAM files created for current XML column |
PGSIZE | 40 | 0X28 | CHAR(10) | Page size of XML VSAM files created for current XML column (4K, 8K, 16K, and so forth) |
DSSIZE | 50 | 0X32 | CHAR(10) | Maximum size (in kilobytes) of XML VSAM files created for current XML column |
DBID | 60 | 0X3C | CHAR(4) | Database identifier (DBID) of database that contains XML table |
PSID | 64 | 0X40 | CHAR(4) | Page set identifier (PSID) of XML table space that contains table |
OBID | 68 | 0X44 | CHAR(4) | Object identifier (OBID) of XML table |
BASEDBID | 72 | 0X48 | CHAR(4) | Database identifier (DBID) of database that contains table with current XML column |
BASEPSID | 76 | 0X4C | CHAR(4) | Page set identifier (PSID) of table space that contains table with current XML column |
BASEOBID | 80 | 0X50 | CHAR(4) | Object identifier (OBID) of table with XML column |
TBCREATOR | 84 | 0X54 | CHAR(128) | Creator of XML table |
TBNAME | 212 | 0XD4 | CHAR(128) | Name of XML table |
COLNAME | 340 | 0X154 | CHAR(128) | Name of current XML column in table that contains XML column |
BASETBNAME | 468 | 0X1D4 | CHAR(128) | Name of table with current XML column |
BASETBCREATOR | 596 | 0X254 | CHAR(128) | Creator of table with current XML column |
NUMROLLS | 724 | 0X2D4 | CHAR(10) | Number of rollback actions that affect current XML column |
NUMMAPRECS | 734 | 0X2DE | CHAR(10) | Number of map records encountered for current XML column |
NUMDATARECS | 744 | 0X2E8 | CHAR(10) | Number of data records encountered for current XML column |
NUMMAPPAGES | 754 | 0X2F2 | CHAR(10) | Number of pages within map records encountered for current XML column |
NUMDATAPAGES | 764 | 0X2FC | CHAR(10) | Number of pages within data records encountered for current XML column |
NUMUPDATES | 774 | 0X306 | CHAR(10) | Number of updates to current XML column |
NUMINSERTS | 784 | 0X310 | CHAR(10) | Number of inserts to current XML column |
NUMDELETES | 794 | 0X31A | CHAR(10) | Number of deletes to current XML column |
CREATERBA | 804 | 0X324 | BIN(10) 1 | Relative byte address (RBA) when XML table was created |
814 | 0X32E | BIN(3) | Reserved | |
ALTERRBA | 816 | 0X330 | BIN(10) 1 | RBA when XML table was altered |
826 | 0X33A | BIN(2) | Reserved | |
DROPPEDRBA | 828 | 0X33C | BIN(10) 1 | RBA when XML table was dropped |
838 | 0X346 | BIN(2) | Reserved | |
CREATETIMESTAMP | 840 | 0X348 | BIN(17) 1 | Db2 timestamp value when XML table was created |
857 | 0X359 | BIN(3) | Reserved | |
ALTERTIMESTAMP | 860 | 0X35C | BIN(17) 1 | Timestamp when XML table was altered |
877 | 0X36D | BIN(3) | Reserved | |
DROPPEDTIMESTAMP | 880 | 0X370 | BIN(17) 1 | Timestamp when XML table was dropped |
897 | 0X381 | BIN(3) | Reserved | |
TABCONCREATERBA | 900 | 0X384 | BIN(10) 1 | RBA when table that contains current XML 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 |
925 | 0X39D | CHAR(10) | Reserved | |
935 | 0X3A7 | CHAR(1) | Reserved | |
VERSIONINGFORMAT | 936 | 0X3A8 | CHAR(1) | Y - The XML is in versioning format N - The XML is not in versioning format |
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 |
EXTENDED | 939 | 0X3AB | CHAR(1) | Y - Extended XML version format N - Basic XML version format |
COLCONVEVENTPT | 940 | 0X3AC | BIN(10) | XML Conversion Event Point |
(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 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