Recovering table spaces to a point on the log

Use the Recover Table Space window to recover data to the current state or to a previous point in time. You can recover a single object, or a list of objects. You can recover an entire table space, partition or data set. When recovering to a log point, the associated index spaces might be put in recovery pending status. Use the Control Center to recover an index to remove the index space from recover pending status.

If you are recovering a set of referentially related table spaces, then you must ensure that you recover the entire set of table spaces to a common quiesce point. If you do not include every member of the set, or if you do not recover the entire set to the same point in time, then recovering a table space can put all dependent table spaces of the inconsistent table spaces in the set in check pending status.

Authorities and privileges.

To recover a table space or index:

  1. Open the Recover To Logpoint window.

  2. Select the LOGONLY check box if you have restored a data set to a point of consistency by using a data set copy that was not made by the DB2 utility COPY. This is because you do not want DB2 utility RECOVER to begin by restoring the data set from a DB2 image copy. Selecting this check box skips the RESTORE phase of RECOVER and applies the log records only, starting from the first log record written after the data set was backed up.
  3. Select the Recover to a point on the log based on check box and specify a point on the log to recover to. The LOGPOINT is in hexadecimal format (X'byte-string'). You can use a log record sequence number (LRSN) or a relative byte address (RBA). The LRSN is a number DB2 generates and associates with each log record. The LRSN is a string of 12 hexadecimal digits.

  4. Select the Use image copies from check box to tell the RECOVER to use image copies from the local or recovery site.

  5. Optional: Click the Add push button to add an object (table space or index).

  6. Optional: Click the Change push button to modify an object (table space or index).

  7. Optional: Click the Remove push button to delete a specified object from the page.

  8. Click OK to begin recovering.