CONFIRM (Verify Constraint Integrity) › CONFIRM › When to Use

When to Use

Use the CONFIRM function when one or both of the following conditions indicate that the integrity of the data in a table must be verified:

• An application receives a return code indicating the table has a CHECK PENDING status.
• A Directory (CXX) report shows the tables to have a CHECK PENDING status. See Directory (CXX) Reports for an example.

The DBUTLTY functions which can result in a CHECK PENDING status for a table are the LOAD function (for details, see LOAD (Build a Data Area)), the LOAD portion of the REORG function (for details, see REORG (Parallel BACKUP)), and the RECOVERY function (for details, see RECOVERY (Rebuild a Database)).

Note: You must CONFIRM tables in the following order, from referenced-to-referencing, or parent-to-child, that is to say, the referenced table cannot be in check pending status. For example, if there is a foreign key from a REMARKS table to a LINE_ITEM table on PO_Nbr and Line_Item_Nbr, and the LINE_ITEM table has a foreign key that references the PO table on PO_Nbr, the PO table must be loaded first, then the LINE_ITEM table can be confirmed, then the REMARKS table can be confirmed. Therefore, the confirm order would be: from PO table to LINE_ITEM table to REMARKS table.