sortbufsize=buffer-size-for-sorting

(a) buffer-size-for-sorting

~<unsigned integer>((256-2097152))<<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.

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 type	Number 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 table	Number of RDAREAs storing the table to be analyzed
Analysis by index	Number of RDAREAs storing the index to be analyzed
Storage condition analysis on cluster keys and clustering data pages	Number of RDAREAs storing the cluster key index to be analyzed