15.2.2 Options

Organization of this subsection
(1) -r {RDAREA-name[,RDAREA-name]...|ALL}...
(2) -k {logi|phys|clus|pred}
(3) -d
(4) -f
(5) -a
(6) -h
(7) -u authorization-identifier
(8) -p password
(9) -t [authorization-identifier.]table-identifier
(10) -s
(11) -i [authorization-identifier.]index-identifier
(12) -q generation-number
(13) -b
(14) -e prediction-level
(15) -w pause-time,segments-count
(16) -n analysis-segments-count
(17) -I
(18) -m
(19) -R monitoring-interval[,maintenance-extension-period]
(20) -c standard-value-definition-file-name
(21) -X response-monitoring-time-for-server-to-server-communication
(22) -v control-statement-file-name

(1) -r {RDAREA-name[,RDAREA-name]...|ALL}...

[Figure]<identifier> ((1-30))

Specifies the names of the RDAREAs to be analyzed. ALL can be specified only for the condition analysis result accumulation facility and the facility for predicting reorganization time.

You can specify the following RDAREA types:

Rules
  1. The same RDAREA name cannot be specified more than once.
  2. If an RDAREA name is enclosed in double quotation marks ("), the command treats it as being case sensitive. If it is not enclosed in double quotation marks ("), the command treats it as in all uppercase letters.
  3. If an RDAREA name contains a space, enclose the RDAREA name in double quotation marks ("). If you are using sh (Bourne shell), csh (C shell), and ksh (Korn shell), you need to enclose the entire RDAREA name in single quotation marks (').
  4. You can specify a maximum of 16 RDAREA names. In the case of a logical analysis (logi specified in the -k option), specify only one RDAREA name (if multiple RDAREA names are specified, the utility uses only the first name specified).
  5. If you are also specifying the -q option, specify the original RDAREA name.
  6. The condition analysis result accumulation facility and the facility for predicting reorganization time use a single transaction to analyze all tables stored in an RDAREA. Therefore, the value of the pd_max_access_tables operand in the system definition must at least equal the number of tables in the RDAREA that contains the greatest number of tables among all target RDAREAs.

(2) -k {logi|phys|clus|pred}

Specifies the type of analysis that is to be executed (by the database condition analysis facility, condition analysis result accumulation facility, or facility for predicting reorganization time).

logi:
Specifies that RDAREA condition analysis (logical analysis) or the condition analysis result accumulation facility is to be executed.
phys:
Specifies that RDAREA condition analysis (physical analysis) is to be executed.
clus:
Specifies that storage condition analysis is to be executed on cluster keys and clustering data pages.
pred:
Specifies that the facility for predicting reorganization time is to be executed.
Combination of -k option and other options:
The values of the -r, -t, and -i options depend on the value of the -k option:
-k option valueWhether or not operation can be specifiedRemarks
-r-t-i
logiMNNCondition analysis by RDAREA (logical analysis)
physMNNCondition analysis by RDAREA (physical analysis)
clusNMNStorage condition analysis on cluster keys and clustering data pages
OmittedNMNCondition analysis by table
NNMCondition analysis by index
MNNCondition analysis by RDAREA (logical analysis)
predONNFacility for predicting reorganization time
Legend:
M: Specification is mandatory
O: Specification is optional
N: Specification is not permitted

(3) -d

Specifies that detailed page information is to be displayed. This option is applicable to logical analysis (-k logi) and condition analysis by table and by index. Whether or not pdrorg and pdreclaim need to be executed depends on this detailed page information.

(4) -f

Specifies that HiRDB file information is to be displayed. This option is applicable to physical analysis (-k phys) only.

(5) -a

Specifies that the analysis results are to be displayed in DAT format.

When this option is specified, the utility assumes that the -f option is specified.

(6) -h

When the -a option is specified, specifies that a header is to be displayed.

(7) -u authorization-identifier

Specifies the authorization identifier of the user executing pddbst.

Rules
  1. If this option is omitted, the authorization identifier and password defined in PDUSER in the client environment definition are assumed. If the PDUSER value is not set, the user name corresponding to the OS user ID of the user executing the utility is assumed.
  2. If a user ID is enclosed in double quotation marks ("), the command treats it as being case sensitive. If it is not enclosed in double quotation marks ("), the command treats it as in all uppercase letters. If you are using sh (Bourne shell), csh (C shell), or ksh (Korn shell), you must enclose the entire user ID in single quotation marks (').

(8) -p password

Specifies the password for the authorization identifier specified in the -u option.

Rules
  1. If this option is not specified and PDUSER is also not set in the client environment definition, the value entered on the utility execution screen is assumed.
  2. If a password is enclosed in double quotation marks ("), the command treats it as being case sensitive. If it is not enclosed in double quotation marks ("), the command treats it as in all uppercase letters. If you are using sh (Bourne shell), csh (C shell), or ksh (Korn shell), you must enclose the entire password in single quotation marks (').

(9) -t [authorization-identifier.]table-identifier

Specifies the name of the table to be analyzed.

Rules
  1. This cannot be a view table or foreign table.
  2. If the authorization identifier is omitted, the authorization identifier specified in the -u option is assumed.
  3. If an authorization identifier or table identifier is enclosed in double quotation marks ("), the command treats it as being case sensitive. If it is not enclosed in double quotation marks ("), the command treats it as in all uppercase letters.
  4. If a table identifier contains a space, enclose it in double quotation marks ("). If you are using sh (Bourne shell), csh (C shell), or ksh (Korn shell), you must enclose the entire identifier in single quotation marks (').

(10) -s

Specifies that the display in the case of table condition analysis is to include the total number of lines stored in the table or the number of lines stored for each RDAREA.

(11) -i [authorization-identifier.]index-identifier

Specifies the name of the index to be analyzed.

Rules
  1. This cannot be an external index.
  2. If the authorization identifier is omitted, the authorization identifier specified in the -u option is assumed.
  3. If an authorization identifier or index identifier is enclosed in double quotation marks ("), the command treats it as being case sensitive. If it is not enclosed in double quotation marks ("), the command treats it as in all uppercase letters.
  4. If an index identifier contains a space, enclose it in double quotation marks ("). If you are using sh (Bourne shell), csh (C shell), and ksh (Korn shell), you need to enclose the entire identifier in single quotation marks (').

(12) -q generation-number

[Figure]<unsigned integer> ((0-10))

Specifies that information about the inner replica facility is to be displayed.

Rules
  1. An error results if this option is specified when HiRDB Staticizer Option has not been installed.
  2. When this option is omitted, the utility assumes that the following RDAREA is to be analyzed:
    [Figure]For condition analysis by RDAREA: RDAREA specified in the -r option
    [Figure]For condition analysis by table or index or storage condition analysis on cluster key and clustering data page: Current RDAREA
  3. This option cannot be specified when you execute the condition analysis result accumulation facility or the facility for predicting reorganization time. When the inner replica facility is used, the utility assumes -q 0.

(13) -b

Specifies that the online performance of applications is to be protected from any adverse effects of executing pddbst. When this option is specified together with the -s option, the analysis time may increase. The -b option is ignored when searching data dictionary tables for a table and indexes that are to be the targets of database condition analysis, and when searching the operation management table by the facility for predicting reorganization time.

Criteria
pddbst first reads a resource page to be analyzed into the global buffer. If a space shortage occurs in the global buffer at that time, online performance may be affected adversely because a page that had already been read by an application may be swept out of the global buffer. To avoid such adverse effects on performance, specify the -b option.
When the -b option is specified, a page read by pddbst is always treated as the oldest page, so that it will be the first page swept out of the global buffer in the event of a space shortage. When the -b option is not specified, the LRU management method is used.
Advantages
Even if a space shortage occurs in the global buffer, there will be no adverse effects on the online performance of applications. However, during execution of pddbst, re-reading of directory pages may occur in order to acquire the requisite number of rows.

(14) -e prediction-level

Specifies the prediction level to be used when the condition analysis result accumulation facility or the facility for predicting reorganization time is applied.

1
Specifies that the condition analysis result accumulation facility or the facility for predicting reorganization time is to be executed in prediction level 1.
2
Specifies that the condition analysis result accumulation facility or the facility for predicting reorganization time is to be executed in prediction level 2.
Rules
  1. Set the same prediction level for both the condition analysis result accumulation facility and the facility for predicting reorganization time.
  2. When the -e option is specified, the utility assumes that the -b option is also specified.

(15) -w pause-time,segments-count

Specifies that the condition analysis result accumulation facility in prediction level 2 is to be executed with the interval analysis method. For details about interval analysis, see 15.6.1 Interval analysis. This method pauses processing for the specified amount of time after the specified number of segments have been analyzed.

pause-time[Figure]<unsigned integer> ((10-60000))
Specifies the pause time, in units of 10 milliseconds. If the specified value is not an even 10 milliseconds, the value is rounded up (for example, 15 is rounded up to 20).
segments-count[Figure]<unsigned integer> ((1-2147483647))
Specifies the number of segments to be analyzed between pauses.
Rules
  1. The -w option is applicable to prediction level 2 (-e 2). Specifying this option in the case of another prediction level results in a control statement error.
  2. In the case of a HiRDB/Parallel Server, the specified value applies to all servers.
  3. If the global buffer contains no page to be analyzed, as many input/output operations as (specified number of segments [Figure] segment size) occur until the pause time is reached.

(16) -n analysis-segments-count

[Figure]<unsigned integer> ((2-10))

Specifies that the condition analysis result accumulation facility in prediction level 2 is to be executed with the merge analysis method. For details about merge analysis, see 15.6.2 Merge analysis.

This method divides a single execution of the condition analysis result accumulation facility into the specified number of analysis segments. Data equivalent to 1/n, where n is the specified number of analysis segments, is the target of each analysis. This means that it takes n executions to analyze all of the target data.

Rules
  1. The -n option is applicable to prediction level 2 (-e 2). Specifying this option in the case of another prediction level results in a control statement error.
  2. When you specify the -n option, you must execute pddbst the specified number of times. If you change the -n option value before the current series of analyses has been completed, the utility ignores the analysis information that has been accumulated so far and starts the analyses over from the beginning.
  3. If maintenance is performed on the target table or index before the entire series of analyses has been completed, the utility starts the analyses over from the beginning.

(17) -I

Specifies that the accumulated condition analysis results are to be reset. For details about resetting the accumulated condition analysis results, see 15.1.3(4) Prediction of reorganization time when the database was not restored to its most recent status after a failure.

Rules
  1. When the -I option is specified, ALL cannot be specified in the -r option.
  2. Specify the -I option only the first time you execute the condition analysis result accumulation facility after data recovery. If the -I option is specified subsequently, all the accumulated condition analysis results will be reset.

(18) -m

Specifies that information about both the scheduled database maintenance date and the maintenance method is to be displayed by the facility for predicting reorganization time. When this option is omitted, the utility displays information about the scheduled database maintenance date only.

(19) -R monitoring-interval[,maintenance-extension-period]

When the facility for predicting reorganization time is executed, specifies the target period and the maintenance extension period.

monitoring-interval[Figure]<unsigned integer> ((1-400)) <<14>>
Specifies the target monitoring interval in days.
For example, to monitor an RDAREA for the next two weeks for scheduling a database maintenance date, specify 14.
maintenance-extension-period[Figure]<unsigned integer> ((0-400)) <<monitoring period/2>>
Specifies the minimum number of days that must elapse between scheduled database maintenance dates.
For example, once database maintenance has been executed, if you wish to require at least one week to elapse before the next database maintenance, specify 7.

(20) -c standard-value-definition-file-name

[Figure]<path name> ((up to 1023 bytes))

When the facility for predicting reorganization time is executed, the utility makes its predictions based on standard values predefined for various items. To change any of the standard values, this option specifies the absolute or relative path name of the standard value definition file.

You specify in the standard value definition file the new standard values for the items. For details about the standard value definition file, see 15.5 Standard value definition file (facility for predicting reorganization time).

(21) -X response-monitoring-time-for-server-to-server-communication

[Figure]<unsigned integer> ((1-65535)) ((300))

If an error, such as a communication error, occurs at the server where the command was executed, the command may stop responding and the application may stop. To help you detect errors, pddbst enables you to monitor a response time during communication for dictionary manipulation that is performed by the command.

You set in the -X option a response monitoring time during dictionary manipulation (in seconds). If the execution time during dictionary manipulation exceeds the value set in the -X option, pddbst treats it as a dictionary access error and cancels processing with return code 8.

Criteria
  • If you want to detect an error in less time than 300 seconds in the event of a no-response from the server due to a communication error or unit down, specify a value less than 300 in the -X option.
  • If the system switchover facility is used, the command may keep waiting for a response even though system switchover has been completed. In such a case, you can terminate the command immediately by reducing the monitoring time.
  • The specified monitoring time may result in a timeout if a response from the dictionary is delayed and the utility's preprocessing is not completed within 300 seconds, which is the default value of the -X option. This can happen when many applications and utilities are executing concurrently. In such an environment, specify a value greater than 300 in the -X option.

(22) -v control-statement-file-name

[Figure]<path name> ((up to 1023 bytes))

Specifies the absolute or relative path name of the file that contains the pddbst control statements.

This file must be located on the host where pddbst is executed. You can specify the following control statements: