20.1.4 File sizes required for the execution of the database condition analysis utility (pddbst)

The following table shows the formulas for determining the file sizes required for the execution of the database condition analysis utility (pddbst):

File typeFormula (bytes)
Work filePhysical analysis in units of RDAREAs60
Logical analysis in units of RDAREAs1 + 3.6 [Figure] {(number of tables and indexes in the RDAREA) + number of LOB RDAREAs}
Accumulating condition analysis result or reorganization time prediction*1 + 3.6 [Figure] {(number of tables and indexes in the RDAREA) + number of LOB RDAREAs}
Status analysis in units of tables1 + 3.6 [Figure] (number of storage RDAREAs)
Status analysis in units of indexes1 + 3.6 [Figure] (number of storage RDAREAs)
Cluster key status analysis1 + 3.6 [Figure] (number of storage RDAREAs)
Work file for sortingWork area for sorting the above work filesValue obtained from the above formula [Figure] 2
* When pddbst -r ALL is specified, the number of resources in the dictionary RDAREAs as well as in the user RDAREAs must be added. For partitioned tables and indexes, add the number for each RDAREA.