The logical log contains one instance of the Open Transaction Record for each transaction that was still in process at the end of log processing.
Field name | Offset | Definition | Description | |
|---|---|---|---|---|
Dec | Hex | |||
CNTLRECORDTYPE | 00 | 00 | CHAR(4) | Control record type: DOTR - Open Transaction Record (Db2) |
URID | 04 | 04 | BIN(10) | Unit of recovery identifier |
14 | 0E | BIN(2) | Reserved | |
URIDLRSN | 16 | 10 | BIN(10) 1 | Unit of recovery LRSN |
26 | 1A | BIN(2) | Reserved | |
MEMBERID | 28 | 1C | CHAR(3) | Member ID if from a data sharing group |
(Total Length) | 31 | 1F | 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
