15.1.2 Condition analysis result accumulation facility

The condition analysis result accumulation facility accumulates database condition analysis results that are required for using the facility for predicting reorganization time.

The condition analysis result accumulation facility executes a logical analysis of the database condition by RDAREA, edits the analysis results, and then stores the results in the database state analyzed table. It is recommended that you execute the condition analysis result accumulation facility on a daily basis.

Figure 15-6 provides an overview of the condition analysis result accumulation facility.

Figure 15-6 Overview of condition analysis result accumulation facility

[Figure]

There are two prediction levels in the condition analysis result accumulation facility, prediction level 1 and prediction level 2. These levels correspond to prediction levels 1 and 2 for the facility for predicting reorganization time. Execution time is longer in prediction level 2 than in prediction level 1 because the former involves more detailed prediction. To execute the condition analysis result accumulation facility in prediction level 2, see 15.6 Executing the condition analysis result accumulation facility in prediction level 2.

Prerequisites for using the condition analysis result accumulation facility:
To use the condition analysis result accumulation facility, you must make the following preparations:
  1. Set pd_rorg_predict=Y in the system definition.
  2. Use pdmod to create a data dictionary RDAREA for storing a database state analyzed table and a database management table.