SYSLGRNX table

The SYSLGRNX table stores recovery log ranges that record the time an index space defined with COPY YES or a table space was open for updates. This provides an efficient way for Db2 to access the appropriate log records for recovery, rather than having to scan every record in the recovery log for a particular table. The schema is SYSIBM.

Column name Data type Description Use
LGRDBID
CHAR(2)
FOR BIT DATA
DBID of the modified object S
LGRPSID
CHAR(2)
FOR BIT DATA
OBID of the modified object S
LGRUCDT CHAR(6) Modification date in the form mmddyy S
LGRUCTM CHAR(8) Modification time in the form hhmmssth S
LGRSRBA1
Start of changeCHAR(10)
FOR BIT DATAEnd of change
Starting RBA S
LGRSPBA1
Start of changeCHAR(10)
FOR BIT DATAEnd of change
Stopping RBA S
LGRPART SMALLINT Partition number in the table space or index space S
LGRSLRSN1
Start of changeCHAR(10)
FOR BIT DATAEnd of change
Starting LRSN of update log records for data sharing. Otherwise, the system clock value that corresponds to the first update log record. S
LGRELRSN1
Start of changeCHAR(10)
FOR BIT DATAEnd of change
Ending LRSN of update log records for data sharing. Otherwise, the system clock value that corresponds to the last update log record. S
LGRMEMB CHAR(2) Data sharing member ID of the modifying Db2 subsystem. X'0000' for a non-data-sharing environment. S
Note: Start of change
  1. A SELECT from SYSIBM.SYSLGRNX displays this column in either 6-byte or 10-byte format. Before CATENFM of SYSLGRNX the data and the display are in 6-byte format. After CATENFM of SYSLGRNX the data and the display are in 10-byte format.
End of change