Recovering a table space to image copy

Use the Table Space Recover to Image Copy window to recover data from image copies of an object and from log records containing changes to the object. If the most recent full image copy data set is unusable, and there are previous image copy data sets existing in the system, then RECOVER uses the previous image copy data sets.

Authorities and privileges.

To recover a table space to an image copy:

  1. Open the Recover To Image Copy window.

  2. In the Partitions or data sets to be recovered box, specify whether all partitions or data sets should be recovered, or only specific partitions or data sets. If you want to recover a specify data set number or partition number, specify the number in the DSNUM field. The default is to recover the entire table space.

  3. Select the Specify a particular page with page number in radio button to designate a data ste to hold the image copy.

  4. In the Image copy data set name field, type the data set name to be used to store the image copy.

  5. Optional: For versions later than DB2 for OS/390 Version 5, if you want to be able to load data into a non-empty data set, select the REUSE check box.
  6. If you want to further identify characteristics of the data set, select the TOVOLUME check box:

  7. Instead of specifying a page number, you can select the ERROR RANGE radio button to recover pages within an error range. This means that all pages within the range of reported I/O errors are to be recovered. Recovering an error range is useful when the range is small relative to the object containing it; otherwise, it is probably better to recover the entire object.

  8. Select the Use image copies from check box to specify using data sets at a recovery site or a local site.
  9. Click OK to begin the table space recover processing.

Related Information