The option statement specifies an option for execution of pddbst.
sortbufsize=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.
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 |