Nonstop Database, HiRDB Version 9 Installation and Design Guide

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

19.2.15 Memory size required for execution of the integrity check utility (pdconstck)

Use the following formulas to determine the size of the memory required to execute the integrity check utility (pdconstck).

Condition Formula for the memory requirement
(KB)
HiRDB single server configuration 32-bit mode 13,995 + [Figure]
64-bit mode 14,766 + [Figure]
HiRDB parallel server configuration 32-bit mode MGR 6,675 + [Figure]
DS 5,910 + [Figure]
64-bit mode MGR 7,252 + [Figure]
DS 8,740 + [Figure]

[Figure]: The value obtained by the following formula:
2,175
+ 0.14 [Figure] number of columns
+ 0.09 [Figure] number of table storage RDAREAs
+ 0.23 [Figure] number of indexes
+ 0.09 [Figure] number of index storage RDAREAs
+ 0.09 [Figure] number of LOB storage RDAREAs
Number of foreign keys
+ [Figure] (42 + 0.47 [Figure] number of foreign key component columns r)
r=1
Number of check constraints
+ [Figure] (5+ 0.29 [Figure] number of columns in the search condition c + 0.85
c=1
[Figure] number of ANDs and ORs in the search condition c + length of the search condition c)

[Figure]: The value obtained from the following formula
0.2
+ 0.02 [Figure] number of table storage RDAREAs
+ 0.02 [Figure] number of index storage RDAREAs
+ 0.02 [Figure] number of LOB column storage RDAREAs