Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Log Master for Db2 13.1.

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').


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*