Scalable Database Server, HiRDB Version 8 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 32-bit mode 11664 + [Figure]
64-bit mode 22696 + [Figure]
HiRDB/Parallel Server 32-bit mode MGR 7577 + [Figure]
DS 5772 + [Figure]
64-bit mode MGR 9240 + [Figure]
DS 12776 + [Figure]

[Figure]: The value obtained by the following formula:
2175
+ 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 foreign keys
+ [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