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.