Open transaction record (DOTR) - Documentation for BMC AMI Log Master for Db2 12.1
Ethan Hayes
Published Apr 07, 2026
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
