Nonstop Database, HiRDB Version 9 Command Reference

[Contents][Index][Back][Next]

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