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 | CHAR(10)FOR BIT DATA ![]() |
Starting RBA | S |
| LGRSPBA1 | CHAR(10)FOR BIT DATA ![]() |
Stopping RBA | S |
| LGRPART | SMALLINT | Partition number in the table space or index space | S |
| LGRSLRSN1 | CHAR(10)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 |
| LGRELRSN1 | CHAR(10)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 |
Note: 


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