Recovering a table space or index to a current state

Use the Recover To Current On Table Space or the Recover To Current On Index window to recover data to the current state or to a previous point in time. You can recover a single table space or index, or a list of table spaces or indexes. You can recover an entire table space, index or a partition or data set. If you have multiple indexes in an index space, you can only recover an entire index space. Output from recovering a table space or index consists of recovered data (either a table space, index, partition or data set).

Authorities and privileges

To recover a table space or index:

Open the Recover To Current window.
Select the Use image copies from check box and decide whether to use from the local or recovery site.
Optional: Click the Add push button to add an object (table space or index).
Optional: Click the Change push button to modify an object (table space or index).
Optional: Click the Remove push button to delete a specified object from the page.
Click OK to begin recovering.

Troubleshooting Tips

Each table space is unavailable for most other applications until recovery is complete. If you make image copies by table space, you can recover the entire table space, or a data set or partition from the table space. If you make image copies separately by partition or data set, you must recover the partitions or data sets by separate RECOVER operations.
If a table space or data set is in the copy pending status, recovering it might not be possible.
Point-in-time recovery can cause table spaces to be placed in check pending status if they have table check constraints or referential constraints defined on them. When recovering tables involved in a referential constraint, you should recover all the table spaces involved in a constraint.