Scalable Database Server, HiRDB Version 8 Installation and Design Guide

[Contents][Index][Back][Next]

19.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 type Formula (bytes)
Work file Physical analysis in units of RDAREAs 60
Logical analysis in units of RDAREAs 1 + 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 tables 1 + 3.6 [Figure] (number of storage RDAREAs)
Status analysis in units of indexes 1 + 3.6 [Figure] (number of storage RDAREAs)
Cluster key status analysis 1 + 3.6 [Figure] (number of storage RDAREAs)
Work file for sorting Work area for sorting the above work files Value 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.