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).

ConditionFormula for the memory requirement
(KB)
HiRDB/Single Server32-bit mode11,664 + [Figure]
64-bit mode22,696 + [Figure]
HiRDB/Parallel Server32-bit modeMGR7,577 + [Figure]
DS5,772 + [Figure]
64-bit modeMGR9,240 + [Figure]
DS12,776 + [Figure]
[Figure]: The value obtained by the following formula:
2,175
+ 0.14 x number of columns
+ 0.09 x number of table storage RDAREAs
+ 0.23 x number of indexes
+ 0.09 x number of index storage RDAREAs
+ 0.09 x number of LOB storage RDAREAs
Number of foreign keys
+ [Figure] (42 + 0.47 x number of foreign key component columns r)
r=1
Number of check constraints
+ [Figure] (5+ 0.29 x number of columns in the search condition c + 0.85
c=1
x 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 x number of table storage RDAREAs
+ 0.02 x number of index storage RDAREAs
+ 0.02 x number of LOB column storage RDAREAs