15.8 Examples

The section shows an example of the use of pddbst.

Organization of this section
(1) Database condition analysis facility
(2) Condition analysis result accumulation facility
(3) Facility for predicting reorganization time

(1) Database condition analysis facility

Example
This example performs condition analysis by table. The table to be analyzed is STOCK.
The example assumes that the STOCK table has been defined as shown in the example for pddef.
Command execution

pddbst -t STOCK

(2) Condition analysis result accumulation facility

Example
This example executes the condition analysis result accumulation facility on an RDAREA named RD001 under the following conditions:
  • Prediction level 2
  • Merge analysis (3 times)
Command execution

pddbst -r RD001 -e 2 -n 3

Note
This command is executed three times.

(3) Facility for predicting reorganization time

Example
This example executes the facility for predicting reorganization time in prediction level 2 based on the analysis information accumulated in (2).
Command execution

pddbst -k pred -e 2