Skip to Content
Information
Limited support BMC 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 REORG PLUS for DB2 13.1.

Referential integrity

REORG PLUS performs no checking for referential constraint violations, nor does it set the CHKP status for reorganizations that result in violations.

To maintain referential integrity, consider the following information:

  • If you use the UPDATE option and update a column that is part of a foreign key, ensure that the new column value does not violate any referential constraints.
  • If you use the SELECT or DELETE option to delete rows from a primary table, you must ensure that the dependent rows are deleted as well.

Related topic

Operational-considerations

 

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

REORG PLUS for DB2 11.2