15.2.5 option statement

The option statement specifies an option for execution of pddbst.

Rules
Only one option statement can be specified in the control statements file.
Organization of this subsection
(1) Format
(2) Explanation

(1) Format

 sortbufsize=buffer-size-for-sorting

(2) Explanation

(a) buffer-size-for-sorting

~<unsigned integer> ((256-2097151)) <<256>>

Specifies in kilobytes the amount of memory that is to be used as the buffer for sort processing on the analysis results.

Rules
Use the formula below as a guideline for determining the buffer size to be specified.
[Figure]
n indicates the number of processing targets. This value depends on the type of analysis, as shown in the table below.

Table 15-2 Number of processing targets for each analysis type

Analysis typeNumber of processing targets
RDAREA condition analysis (logical analysis)Total number of tables and indexes defined in the RDAREAs to be analyzed
RDAREA condition analysis (physical analysis)Number of RDAREAs to be analyzed
Analysis by tableNumber of RDAREAs storing the table to be analyzed
Analysis by indexNumber of RDAREAs storing the index to be analyzed
Storage condition analysis on cluster keys and clustering data pagesNumber of RDAREAs storing the cluster key index to be analyzed