20.1.3 File sizes required for the execution of the statistics analysis utility (pdstedit)

The following table shows the formulas for determining the file sizes required for the execution of the statistics analysis utility (pdstedit):

File typeFormula (bytes)
Work fileStatistical information about system activity4096 [Figure] collection count*[Figure] 2
Statistical information about system activity per server4096 [Figure] collection count*[Figure] number of servers [Figure] 2
Statistical information about UAPs800 [Figure] number of UAPs to be executed or number of transactions to be executed [Figure] 2
Statistical information about SQL512 [Figure] number of SQLs to be executed [Figure] 2
Statistical information about SQL static optimization512 [Figure] SQL object cache mishit count
Statistical information about SQL dynamic optimization8192 [Figure] number of SELECT statements issued by OPEN or EXECUTE (including INSERT SELECT)
Statistical information about SQL object execution512 [Figure] number of SQLs to be executed [Figure] number of servers
Statistical information about SQL object transfer256 [Figure] number of SQLs to be executed [Figure] number of servers
Statistical information about the history of SQL statements(1024 + average SQL length) [Figure] number of SQLs to be executed
Statistical information about CONNECT/DISCONNECT256 [Figure] number of CONNECTs and DISCONNECTs
Statistical information about global buffer512 [Figure] number of synchronization points [Figure] 2
Statistical information about database manipulation for HiRDB files512 [Figure] number of synchronization points [Figure] 2
Statistical information about deferred write processing512 [Figure] number of deferred write operations [Figure] 2
Statistical information about indexes (input: STJ)128 [Figure] number of synchronization points [Figure] 2
Statistical information about indexes (input: FJ)128 [Figure] number of page splits [Figure] 2
Statistical information about foreign server activity512 [Figure] number of transactions that accessed foreign servers
Statistical information about foreign server utilization status512 [Figure] number of SQL statements executed on foreign servers
Work file for sortingWork area for sorting the above work files for analysisMaximum size of the above work files for analysis
DAT-
format file
Statistical information about system activity3262 [Figure] collection count*
Statistical information about system activity per server3262 [Figure] collection count*[Figure] number of servers
Statistical information about UAPs1410 [Figure] number of UAPs to be executed or number of transactions to be executed
Statistical information about SQL447 [Figure] number of SQLs to be executed
Statistical information about SQL static optimization646 [Figure] SQL object cache mishit count
Statistical information about SQL dynamic optimization380 [Figure] number of SELECT statements issued by OPEN or EXECUTE (including INSERT SELECT)
Statistical information about SQL object execution520 [Figure] number of SQLs to be executed [Figure] number of servers
Statistical information about SQL object transfer389 [Figure] number of SQLs to be executed [Figure] number of servers
Statistical information about the history of SQL statements(240 + average SQL length) [Figure] number of SQLs to be executed
Statistical information about CONNECT/DISCONNECT278 [Figure] number of CONNECTs and DISCONNECTs
Statistical information about global buffer567 [Figure] number of synchronization points
Statistical information about database manipulation for HiRDB files356 [Figure] number of synchronization points
Statistical information about deferred write processing300 [Figure] number of deferred write operations
Statistical information about foreign server activity374 [Figure] number of transactions that accessed foreign servers
Statistical information about foreign server utilization status389 [Figure] number of SQL statements executed on foreign servers
* Collection count = [Figure](pdstend command input time - pdstbegin command input time) [Figure] interval specified with the -m option[Figure]