The CHECK Utility

The CHECK Utility

The CHECK utility checks the integrity of DB2 data structures. It has three purposes. The first is to check referential integrity between two tables, displaying and potentially resolving referential constraint violations. The second purpose of the CHECK utility is to ensure that data values conform to the check constraints specified for the table. The third and final purpose is to check DB2 indexes for consistency. This consists of comparing the key values of indexed columns to their corresponding table values, as well as evaluating RIDs in the tables and indexes being checked.