Scalable Database Server, HiRDB Version 8 Command Reference

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

15.2.1 Format

Organization of this subsection
(1) For the database condition analysis facility
(2) For the condition analysis result accumulation facility
(3) For the facility for predicting reorganization time

(1) For the database condition analysis facility

Condition analysis by RDAREA
 
  pddbst -r RDAREA-name[,RDAREA-name]...
        [-k {logi [-d]|phys [-f] [-a [-h]]}] [-u user-ID [-p password]]
         [-b]
        [-X response-monitoring-time-for-server-to-server-communication]
        [-v control-statements-file-name]
 

Condition analysis by table
 
  pddbst -t [authorization-identifier.]table-identifier
        [-s] [-u user-ID [-p password]] [-d]
         [-b]
        [-X response-monitoring-time-for-server-to-server-communication]
        [-v control-statements-file-name]
 

Condition analysis by index
 
  pddbst -i [authorization-identifier.]index-identifier
        [-u user-ID [-p password]] [-d]
         [-b]
        [-X response-monitoring-time-for-server-to-server-communication]
        [-v control-statements-file-name]
 

Storage condition analysis on cluster keys and clustering data pages
 
  pddbst -t [authorization-identifier.]table-identifier
        [-u user-ID [-p password]] -k clus
         [-b]
        [-X response-monitoring-time-for-server-to-server-communication]
        [-v control-statements-file-name]
 

(2) For the condition analysis result accumulation facility

 
  pddbst -r {RDAREA-name|ALL} [-k logi] -e prediction-level
        [-w pause-time,segments-count] [-n analysis-segments-count] [-I]
        [-u authorization-identifier [-p password]]
        [-X response-monitoring-time-for-server-to-server-communication]
        [-v control-statements-file-name]
 

(3) For the facility for predicting reorganization time

 
  pddbst [-r ALL] -k pred -e prediction-level
        [-m] [-R monitoring-interval[,maintenance-extension-period]]
        [-c standard-value-definition-file-name] [-u authorization-identifier [-p password]]
        [-X response-monitoring-time-for-server-to-server-communication]
        [-v control-statements-file-name]