Automatic recovery of indexes from GRECP or LPL status
Db2 11 improves system and application availability by extending support for the automatic recovery of indexes that are in group buffer pool recovery pending (GRECP) or logical page list (LPL) status during GRECP or LPL recovery.
In earlier versions of Db2, if an index page split or index page delete operation is unfinished when an index is put into GRECP or LPL status, the GRECP or LPL recovery might fail, and the index can be left in REBUILD-pending status. In these cases, a database administrator must rebuild the index, which is a time-consuming process.
Now, Db2 automatically uses second pass log apply to initiate recovery of an index that is in GRECP or LPL status. This enhancement makes the indexes immediately available after GRECP or LPL recovery.
In some rare cases when you run the RECOVER utility or RESTORE SYSTEM utility, an index might be left in REBUILD-pending status. In these cases, you must rebuild the index by running the REBUILD INDEX utility.