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 REORG PLUS for DB2 13.1.

Conditional reorganization

A conditional reorganization means that REORG PLUS performs the reorganization only if it is needed.

The CONDEXEC command and installation options tell REORG PLUS whether to check the criteria for a conditional reorganization. The CONDEXEC options also tell REORG PLUS whether to use information from the Db2 catalog (CONDEXEC YES) or the DASD MANAGER PLUS exceptions table (CONDEXEC BMC). Using the exceptions table allows you to set more conditions that might cause the reorganization to be performed. However, the BMC value is available only if you are using REORG PLUS as part of the BMC AMI Database Performance for Db2 or Database Performance for DB2 solution. For more information about the BMC value, see Conditional-reorganizations-using-the-DASD-MANAGER-PLUS-exceptions-table.

Important

Conditional execution is not supported when you are reorganizing LOB table spaces. REORG PLUS terminates if you are reorganizing a LOB table space, and command or installation options would cause REORG PLUS to check the criteria for a conditional reorganization.

The following topics provide more details about conditional reorganization:

Related topic

Operational-considerations

 

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