Checking index consistency

Use the Check Index window to check that indexes are consistent with the data that they index.

The Check Index window displays the selected indexes in a table. This table displays the index name, the index space, partition information, the associated table name, the index type, and the indexes' buffer pool.

Authorities and privileges

To check an index:

  1. Open the Check Index window.
  2. Type information in the Data set name, Device, and Space fields inside the Temporary work data set group box.

    3. DB2 uses the information that you type in these fields to identify the temporary work files used during CHECK INDEX. If you do not specify a temporary work file, DB2 uses the default, SYSUT1.
  3. In the Device type for DFSORT temporary data sets (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 for DFSORT temporary data sets (SORTDEVT) field, you can specify any IBM direct access storage device or tape device supported by your operating system.
  4. If you want to specify the maximum number of data sets, select the Number of DFSORT temporary data sets check box. Type a number in the 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. Tip: To optimize resource allocation, avoid specifying a large number of work data sets unnecessarily.

  5. Click OK.


Related information