Recovering a table space and all of its indexes

You can recover a table space and all of its indexes (or a table space set and all related indexes). Use a single RECOVER utility statement that specifies the TOLOGPOINT option.

About this task

For the log point, you can identify a quiesce point or a common SHRLEVEL REFERENCE copy point. This action avoids placing indexes in the CHECK-pending or RECOVER-pending status. If the log point is not a common quiesce point or SHRLEVEL REFERENCE copy point for all objects, use the following procedure, which ensures that the table spaces and indexes are synchronized and eliminates the need to run the CHECK INDEX utility.

With recovery to a point in time with consistency, which is the default recovery type, you do not need to identify a quiesce point or a common SHRLEVEL REFERENCE copy point. This recovery might be faster because inconsistencies do not have to be resolved.

Procedure

To recover to a log point:

  1. Use the RECOVER utility to recover table spaces to the log point.
  2. Use concurrent REBUILD INDEX jobs to rebuild the indexes for each table space.