Resetting CHECK-pending status

If a table space has a status of CHECK-pending (CHKP), you can remove this status by correcting the error and running the CHECK DATA utility.

Procedure

To reset CHECK-pending status:

Run CHECK DATA with SHRLEVEL REFERENCE and one of the following DELETE values:
  • Specify DELETE YES to remove all rows that violate referential or table check constraints.
  • Specify DELETE NO if the tables do not contain any rows that violate referential or table check constraints or you want to detect the errors only. If you specify DELETE NO and any of these violations are found, the table space remains in CHECK-pending status. In this case, you need to correct the errors and run CHECK DATA again to reset this status.

Results

If no inconsistencies remain in the table space, CHECK-pending status is reset.