Nonstop Database, HiRDB Version 9 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 by RDAREA 1 + 4.1 [Figure] a
Logical analysis by RDAREA a
1 + 4.1 [Figure] [Figure](
i=1
number of tables in RDAREAi
+ number of indexesi
+ number of LOB RDAREAsi)
Accumulating condition analysis result or reorganization time prediction# a
1 + 4.1 [Figure] [Figure](
i=1
number of tables in RDAREAi
+ number of indexesi
+ number of LOB RDAREAsi)
Status analysis in units of tables 1 + 4.1 [Figure] (number of storage RDAREAs)
Status analysis in units of indexes 1 + 4.1 [Figure] (number of storage RDAREAs)
Cluster key status analysis 1 + 4.1 [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.

a: Number of RDAREAs subject to analysis