Log information end record (DLGE)
Each logical log contains one instance of the Log Information End Record. This record type contains information about the end point and RBA/LRSN data in the logical log.
Record Status: Db2 specific
Field name | Offset | Definition | Description | |
---|---|---|---|---|
Dec | Hex | |||
CNTLRECORDTYPE | 00 | 00 | CHAR(4) | Control record type: DLGE - Logical Log Information End Record (Db2) |
ENDRBA | 04 | 04 | BIN(10) 1 | Ending RBA/LRSN for logical log file |
14 | 0E | BIN(2) | Reserved | |
ENDTIME | 16 | 10 | BIN(17) 1 | Time that the product finished creating the logical log file |
33 | 21 | BIN(3) | Reserved | |
DEPENDENTRBA | 36 | 24 | BIN(10) 1 | The RBA/LRSN of the oldest unit of recovery (lowest RBA/LRSN value) within the current logical log that contains at least one log record that Log Master was unable to complete |
46 | 2E | BIN(2) | Reserved | |
(Total Length) | 48 | 30 | 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