Checking index consistency

Use the Table Space Check Index window to check that index in table spaces are consistent with the data they index. The Check Index window displays the selected table spaces with the partition information and the indexes' buffer pool.

Authorities and privileges

To check an index:

  1. Open the Check 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 CHECK INDEX. If you do not specify a temporary work file, the 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.

    Tip: To optimize resource allocation, avoid specifying a large number of work data sets unnecessarily.

  5. Click OK to process the check.
Related information