BMCLGRNX table

This topic describes the BMCLGRNX table, which contains log ranges that show when a table space was open for updates.


Related topics

Command-and-syntax-reference

Examples-of-CHECK-PLUS-jobs

CHECK-command-syntax

SQL-batch-execution-program

Common-utility-tables


Column name

Data type

Description

LGRDBID

CHAR(2)

DBID of the modified object.

LGRPSID

CHAR(2)

OBID of the modified object.

LGRUCDT

CHAR(6)

Modification date (mmddyy)

LGRUCTM

CHAR(8)

Modification time (hhmmssth)

LGRSRBA

CHAR(6)

Starting RBA

LGRSPBA

CHAR(6)

Stopping RBA

LGRPART

SMALLINT

Table space partition number.

LGRSLRSN

CHAR(6)

Starting LRSN of update log records for data sharing.

For non-data-sharing, the value is X'000000000000'.

LGRELRSN

CHAR(6)

Ending LRSN of update log records for data sharing.

For non-data-sharing, the value is X'000000000000'.

LGRMEMBER

CHAR(2)

Data sharing member ID of the modifying Db2 subsystem.

For non-data-sharing, the value is X'0001'.

 

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