Upgrading from Version 9.7.1

Back Next

Step 8. Ensure Table Constraints Reconcile

Ensure that all table constraints reconcile and that a table is not in the check pending state.

Verify that all the fields in the CONST_CHECKED column of the SYSIBM.SYSTABLES are set to

When a table is in the check pending state, fields in the CONST_CHECKED column are set to

If a table is in the check pending state, run the following SET INTEGRITY command for the table:

set integrity for <schema_name.table_name> immediate checked

All the table constraints are reconciled and the check pending state is removed.