Recovering a table space

Use the Table Space Recover window to recover data to the current state or to a previous point in time. Recovering one or more table spaces recovers an entire table space, a partition or data set, pages within an error range, or a single page. You recover data from image copies of a table space and from log records containing changes to the table space. If the most recent full image copy data set is unusable, and previous image copy data sets exist in the system, then when you recover a table space, the utility uses the previous image copy data sets. With a point-in-time recovery, it is not necessary to take a full image copy after recovering, except in the case of fallback recovery. DB2 records the RBAs associated with the point-in-time recovery in catalog table SYSIBM.SYSCOPY to allow future recover operations to skip the unwanted range of log records.

Because a point-in-time recovery leaves data in a consistent state and indexes in an inconsistent state, all indexes must be recovered by running a recover index from the Control Center.

Authorities and privileges.

To recover a table space:

Open the Recover Table Space window.
Specify the options appropriate for the table space or table spaces that are listed in the table.

Optional: If you are recovering to current:

Select theUse image copies from check box and decide whether to use from the local or recovery site.

Optional: If you are recovering to a log point:

Select the Apply only log records to data sets 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.
Select the Recover to a point on the log based on check box and specify a LOGPOINT in hexadecimal format.
Select the Use image copy from check box and specify whether to use image copies from a local or from a recovery site.
Specify one of the radio buttons in the Parallel processing options. You can
1. choose whether to recover the table space without using parallel processing
2. let DB2 decide the number of table spaces to process in parallel
3. choose the number of table spaces to process in parallel

Ensure that all of the table spaces you want to recover are listed in the window. You can use the Add, Change, or Remove push buttons as needed.
Click OK to begin the table space recover processing.

Related Information

About table spaces.

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.