The following table shows the formulas for determining the file sizes required for the execution of the statistics analysis utility (pdstedit):
File type | Formula (bytes) |
---|
Temporary work file | Statistical information about system activity | 4,096 x collection count# x 2 |
Statistical information about system activity per server | 4,096 x collection count# x number of servers x 2 |
Statistical information about UAPs | 872 x number of UAPs to be executed or number of transactions to be executed x 2 |
Statistical information about SQL | 512 x number of SQLs to be executed x 2 |
Statistical information about SQL static optimization | 512 x SQL object cache mishit count |
Statistical information about SQL dynamic optimization | 49,624 x number of SELECT statements issued by OPEN or EXECUTE (including INSERT SELECT) |
Statistical information about SQL object execution | 512 x number of SQLs to be executed x number of servers |
Statistical information about SQL object transfer | 256 x number of SQLs to be executed x number of servers |
Statistical information about the history of SQL statements | (1,024 + average SQL length) x number of SQLs to be executed |
Statistical information about CONNECT/DISCONNECT | 256 x number of CONNECTs and DISCONNECTs |
Statistical information about global buffer | 512 x number of synchronization points x 2 |
Statistical information about database manipulation for HiRDB files | 512 x number of synchronization points x 2 |
Statistical information about deferred write processing | 512 x number of deferred write operations x 2 |
Statistical information about indexes (input: STJ) | 128 x number of synchronization points x 2 |
Statistical information about indexes (input: FJ) | 128 x number of page splits x 2 |
Work file for sorting | Work area for sorting the above types of temporary work files for analysis | Maximum size of the temporary work files that will be needed for analysis |
DAT- format file | Statistical information about system activity | 3,404 x collection count# |
Statistical information about system activity per server | 3,262 x collection count# x number of servers |
Statistical information about UAPs | 1,991 x number of UAPs to be executed or number of transactions to be executed |
Statistical information about SQL | 447 x number of SQLs to be executed |
Statistical information about SQL static optimization | 646 x SQL object cache mishit count |
Statistical information about SQL dynamic optimization | 380 x number of SELECT statements issued by OPEN or EXECUTE (including INSERT SELECT) |
Statistical information about SQL object execution | 520 x number of SQLs to be executed x number of servers |
Statistical information about SQL object transfer | 389 x number of SQLs to be executed x number of servers |
Statistical information about the history of SQL statements | (240 + average SQL length) x number of SQLs to be executed |
Statistical information about CONNECT/DISCONNECT | 278 x number of CONNECTs and DISCONNECTs |
Statistical information about global buffer | 600 x number of synchronization points |
Statistical information about database manipulation for HiRDB files | 356 x number of synchronization points |
Statistical information about deferred write processing | 300 x number of deferred write operations |