Recovering indexes

Use this window to recover index data to a previous state. Indexes are recovered by re-creating them from the tables on which they are based. It can recover one or more partitions of a partitioned index in a partitioned table space.

Authorities. Authorities and privileges

To check data in a table space:

  1. Open the Table Space Recover Index window.

  2. In the Temporary work data set fields, type a Data set name, a Device , and a Space in the text fields. DB2 uses the information that you type in this field to identify the temporary work files used during RECOVER INDEX. If you do not specify a temporary work file, DB2 uses the default, SYSUT1.

  3. In the SORTDEVT field, type a device type for the data facility sort (DFSORT). DFSORT is a non-DB2 utility used to sort, merge, and copy information. In the device type field, you can specify any IBM direct access storage device or tape device supported by your operating system.

  4. In the SORTNUM field, select the Number of DFSORT temporary data sets check box if you want to specify the maximum number of data sets. If you select the check box, type a number in the associated text field. You can type a number between 1 and 255. If you do not select this check box, DFSORT uses a default maximum number of data sets.

  5. Click OK to recover the listed indexes.

Related information