Check Index

Go Up to Available object actions by DBMS

The Check Index Wizard lets you test whether indexes are consistent with the data they index. The Wizard issues warning messages when an inconsistency is found.

Run the Check Index action after a conditional restart or a point-in-time recovery on all tablespaces where you suspect that the indexes may not be consistent with the data. Also run the wizard before executing the Check Data action to ensure that the indexes used by the Check Data Wizard are valid (see Check Data). This is especially important before using the Check Data with DELETE YES.

When checking an auxiliary table index, the Check Index Wizard verifies that each LOB is represented by an index entry, and that an index entry exists for every LOB.

Platform Availability

• DB2 z/OS

To Check Index/Data Consistency

1. Initiate a Check Index action against a tablespace or index. For more information see Initiating an object operation.
2. Use the following table as a guide to understanding and modifying settings in the Check Index Utility wizard:

Step	Settings and tasks
1	Select Index	If you initiated the Check Index operation against one or more indexes, the target indexes are initially displayed. To check additional Indexes, click the Add button.
	Add	Opens the Indexes Selector dialog.
	Delete	Deletes selected index.
2	Select tablespaces	If you initiated the Check Index operation against one or more tablespaces, the target tablespaces are initially displayed. To check additional tablespaces, click the Add button.
	Add	Opens the Object Selector Dialog Box.
	Delete	Deletes selected tablespace.
3	Do you want the utility to be restartable?	Lets you specify to execute Wizard in restartable mode. You can restart it from the Datasource Navigator/Explorer.
	Work DDN	Lets you specify the name of a work data definition (DD) statement that corresponds to a data control block that contains the same name. Lets you select a previously saved dataset template or click Edit to open the Dataset Template Editor.
	Do you want to specify the device type for temporary data sets by DFSORT?	Lets you specify the device type for temporary data sets to be dynamically allocated by DFSORT.
	Do you want to specify the sort number?	Lets you type the number of datasets to be dynamically allocated by the sort program. The range of the text field is 0 to 2147483647.

3. When ready, click Finish.