Recovering a table space or index to imagecopy

Use the Recover to Image Copy on Table Space or the Recover To Image Copy On Index 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 or index 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 specific data set number or partition number, specify the number in the field. The default is to recover all.
  3. Select one of the following radio buttons:
    TOCOPY
    If you want to recover to a particular backup copy, select the TOCOPY radio button. Important: It is not possible to recover to an image copy data set that is not referred to in a SYSIBM.SYSCOPY row for that table space or data set. An attempt to do so results in a TOCOPY DATASET NOT FOUND message. The SYSIBM.SYSCOPY row might have been removed by the MODIFY utility. If this happened, and the image copy is a full image copy with SHRLEVEL REFERENCE, the table space or data set can be restored with DSN1COPY.

    1. Specify the name of the image copy data set in the Image copy data set name field. You can type the data set name or select from the list of data sets. This is the data set to which you previously copied. Select Report from the table space folder in the Control Center to verify the data set device and space information.

    2. 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.

    3. If you want to further identify characteristics of the data set select the TOVOLUME check box and one of the following radio buttons:

      Cataloged

      To identify the data set as cataloged. Use this option only for an image copy that was created as a cataloged data set. (Its volume serial is not recorded in SYSIBM.SYSCOPY.)

      Non cataloged

      To identify a non-cataloged data set. Then type the First volume serial identifier (an alphanumeric number), and the File sequence number in the fields.

    ERROR RANGE
    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.
  4. If you want to use image copies at a local or recovery site, select the Use image copies from check box and specify a recovery site or a local site. In preparation for remote site recovery, system and application libraries and the DB2 catalog and directory are assumed to be identical at the local site and recovery site. You can regularly transport copies of archive logs and database data sets to a safe location to keep data for remote site recovery current. This information can be kept on tape until needed.

  5. Click OK to begin the table space recover processing.

Related information