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]...|ALL}
           [-k {logi [-d] [-z]|phys [-f]}]
        -a [-h]] [-u user-ID [-p password]]
       [-q generation-number] [-b]
       [-X response-monitoring-time-for-server-to-server-communication]
       [-v control-statements-file-name]
       [-W execution-monitoring-interval]

Condition analysis by table

 pddbst -t [authorization-identifier.]table-identifier
       [-s] [-u user-ID [-p password]] [-d] [-z]
       [-q generation-number] [-b]
       [-X response-monitoring-time-for-server-to-server-communication]
       [-v control-statements-file-name]
       [-W execution-monitoring-interval]

Condition analysis by index

 pddbst -i [authorization-identifier.]index-identifier
       [-u user-ID [-p password]] [-d] [-z]
       [-q generation-number] [-b]
       [-X response-monitoring-time-for-server-to-server-communication]
       [-v control-statements-file-name]
       [-W execution-monitoring-interval]

Storage condition analysis on cluster keys and clustering data pages

 pddbst -t [authorization-identifier.]table-identifier
       [-u user-ID [-p password]] -k clus
       [-q generation-number] [-b]
       [-X response-monitoring-time-for-server-to-server-communication]
       [-v control-statements-file-name]
       [-W execution-monitoring-interval]

(2) For the condition analysis result accumulation facility

 pddbst -r {RDAREA-name[,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]
       [-W execution-monitoring-interval]

(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]
       [-W execution-monitoring-interval]