SYSIBM.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.

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
LGRSRBA	CHAR(6) FOR BIT DATA	Starting RBA	S
LGRSPBA	CHAR(6) FOR BIT DATA	Stopping RBA	S
LGRPART	SMALLINT	Partition number in the table space or index space	S
LGRSLRSN	CHAR(6) FOR BIT DATA	Starting LRSN of update log records for data sharing. Otherwise, the system clock value that corresponds to the first update log record.	S
LGRELRSN	CHAR(6) FOR BIT DATA	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