Resetting CHECK-pending status

If a table space has a status of CHECK-pending, you can remove the CHECK-pending status by correcting the error and running a utility job. You can either rerun the CHECK DATA utility with SHRLEVEL REFERENCE specified or you can run the REPAIR utility.

To remove CHECK-pending status by running the CHECK DATA utility, use the following approaches:

• Use the DELETE NO option if no tables contain rows that violate referential or table check constraints. If referential or table check constraint violations are found, the table space or partition is placed in CHECK-pending status.
• Use the DELETE YES option to remove all rows that violate referential or table check constraints.