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 collection count* 2
	Statistical information about system activity per server	4096 collection count* number of servers 2
	Statistical information about UAPs	800 number of UAPs to be executed or number of transactions to be executed 2
	Statistical information about SQL	512 number of SQLs to be executed 2
	Statistical information about SQL static optimization	512 SQL object cache mishit count
	Statistical information about SQL dynamic optimization	8192 number of SELECT statements issued by OPEN or EXECUTE (including INSERT SELECT)
	Statistical information about SQL object execution	512 number of SQLs to be executed number of servers
	Statistical information about SQL object transfer	256 number of SQLs to be executed number of servers
	Statistical information about the history of SQL statements	(1024 + average SQL length) number of SQLs to be executed
	Statistical information about CONNECT/DISCONNECT	256 number of CONNECTs and DISCONNECTs
	Statistical information about global buffer	512 number of synchronization points 2
	Statistical information about database manipulation for HiRDB files	512 number of synchronization points 2
	Statistical information about deferred write processing	512 number of deferred write operations 2
	Statistical information about indexes (input: STJ)	128 number of synchronization points 2
	Statistical information about indexes (input: FJ)	128 number of page splits 2
	Statistical information about foreign server activity	512 number of transactions that accessed foreign servers
	Statistical information about foreign server utilization status	512 number of SQL statements executed on foreign servers
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 collection count*
	Statistical information about system activity per server	3262 collection count* number of servers
	Statistical information about UAPs	1410 number of UAPs to be executed or number of transactions to be executed
	Statistical information about SQL	447 number of SQLs to be executed
	Statistical information about SQL static optimization	646 SQL object cache mishit count
	Statistical information about SQL dynamic optimization	380 number of SELECT statements issued by OPEN or EXECUTE (including INSERT SELECT)
	Statistical information about SQL object execution	520 number of SQLs to be executed number of servers
	Statistical information about SQL object transfer	389 number of SQLs to be executed number of servers
	Statistical information about the history of SQL statements	(240 + average SQL length) number of SQLs to be executed
	Statistical information about CONNECT/DISCONNECT	278 number of CONNECTs and DISCONNECTs
	Statistical information about global buffer	567 number of synchronization points
	Statistical information about database manipulation for HiRDB files	356 number of synchronization points
	Statistical information about deferred write processing	300 number of deferred write operations
	Statistical information about foreign server activity	374 number of transactions that accessed foreign servers
	Statistical information about foreign server utilization status	389 number of SQL statements executed on foreign servers

^* Collection count = (pdstend command input time - pdstbegin command input time) interval specified with the -m option