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.

ANALYZE phase

The ANALYZE phase provides information about the number of rows (cardinality) and the average row size of the data to be reorganized.

The following performance factors arise from the ANALYZE phase, and command options that you specify control these factors:

  • Amount of time that the phase requires to run
  • Accuracy of the information gathered during the phase

The following figures show the objects that the ANALYZE phase might use (except ANALYZE HURBA, which uses no objects).


ANALYZE phase for a table space reorganization

ANALYZE_phase_table_space.png

ANALYZE phase for an index reorganization

ANALYZE_phase_index.png

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