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.
Tip:
If
the table space is in CHKP status because of a particular referential constraint or check
constraint, specify the SCOPE PENDING option or the SCOPE REFONLY option in the CHECK DATA
statement to reduce utility processing time. You can check whether a constraint is the cause
of the CHKP status by issuing the DISPLAY DATABASE command with the RESTRICT(CHKP)
option.
- Run
CHECK DATA with SHRLEVEL CHANGE. If any REPAIR utility statements are generated in the PUNCHDDN data
set, run those statements to fix the errors. Then, run CHECK DATA again to reset the
status.