Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see CHECK PLUS for DB2 13.1.

User-defined RI

When you use CHECK PLUS to define RI rules outside of the Db2 facilities, you must be aware of several operational factors. First, user-defined RI is managed entirely outside of Db2’s facilities for enforcing RI. If you save user-defined RI rules, they are stored in tables in the CHECK PLUS database, not in the Db2 catalog tables. Any user-defined RI rules that are saved in the CHECK PLUS database are automatically used for subsequent utility executions when CHECK DATA runs against table spaces included in those rules.

If you make changes to the data structures that affect the user-defined RI rules, or if you want to change the rules themselves, you need to modify the CHECK PLUS RI rules tables by using SQL statements. Alternatively, you can delete rules by using SQL statements and then specify new rules in the CHECK DATA control statements with SAVERULES YES. For definitions of these tables, see CHECK PLUS RI rules tables.

If you have user-defined RI rules specified through CHECK PLUS and then you specify the same rules through Db2-defined RI, you should delete the rules in the CHECK PLUS RI rules tables. CHECK PLUS issues an error message if it detects duplicate rules specifications.

The CHECKRID values in the Db2 catalog are independent of user-defined RI rules. If you specify the SCOPE PENDING option, CHECK PLUS starts checking the rows for Db2 RI and user-defined RI as indicated by the CHECKRID value.

Related topics

Building-CHECK-PLUS-jobs

Operational-considerations

CHECK-PLUS-installation-options


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*