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) | |
---|---|---|
Work file | Statistical information about system activity | 4096 ![]() ![]() |
Statistical information about system activity per server | 4096 ![]() ![]() ![]() | |
Statistical information about UAPs | 800 ![]() ![]() | |
Statistical information about SQL | 512 ![]() ![]() | |
Statistical information about SQL static optimization | 512 ![]() | |
Statistical information about SQL dynamic optimization | 8192 ![]() | |
Statistical information about SQL object execution | 512 ![]() ![]() | |
Statistical information about SQL object transfer | 256 ![]() ![]() | |
Statistical information about the history of SQL statements | (1024 + average SQL length) ![]() | |
Statistical information about CONNECT/DISCONNECT | 256 ![]() | |
Statistical information about global buffer | 512 ![]() ![]() | |
Statistical information about database manipulation for HiRDB files | 512 ![]() ![]() | |
Statistical information about deferred write processing | 512 ![]() ![]() | |
Statistical information about indexes (input: STJ) | 128 ![]() ![]() | |
Statistical information about indexes (input: FJ) | 128 ![]() ![]() | |
Statistical information about foreign server activity | 512 ![]() | |
Statistical information about foreign server utilization status | 512 ![]() | |
Work file for sorting | Work area for sorting the above work files for analysis | Maximum size of the above work files for analysis |
DAT- format file | Statistical information about system activity | 3262 ![]() |
Statistical information about system activity per server | 3262 ![]() ![]() | |
Statistical information about UAPs | 1410 ![]() | |
Statistical information about SQL | 447 ![]() | |
Statistical information about SQL static optimization | 646 ![]() | |
Statistical information about SQL dynamic optimization | 380 ![]() | |
Statistical information about SQL object execution | 520 ![]() ![]() | |
Statistical information about SQL object transfer | 389 ![]() ![]() | |
Statistical information about the history of SQL statements | (240 + average SQL length) ![]() | |
Statistical information about CONNECT/DISCONNECT | 278 ![]() | |
Statistical information about global buffer | 567 ![]() | |
Statistical information about database manipulation for HiRDB files | 356 ![]() | |
Statistical information about deferred write processing | 300 ![]() | |
Statistical information about foreign server activity | 374 ![]() | |
Statistical information about foreign server utilization status | 389 ![]() |