Open transaction record (DOTR)
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.
Record Status: Db2 specific
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
Was this page helpful? Yes No
Submitting...
Thank you
Comments
Log in or register to comment.