Skip to Content

ANALYZE phase

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

Two considerations arise from the ANALYZE phase and are controlled by the command options that you specify:

  • The amount of time that the phase requires to run
  • The accuracy of the information that LOADPLUS gathers during the phase

Related topic

Processing-phases

The following figure shows the objects that the ANALYZE phase uses to determine the information that it provides:

ANALYZE_phase.png


 

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

LOADPLUS for DB2 13.1