Scalable Database Server, HiRDB Version 8 Installation and Design Guide

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

19.1.10 File sizes required for execution of the integrity check utility (pdconstck)

The following table shows the formulas for determining the file sizes required for execution of the integrity check utility (pdconstck).

File type Formula (bytes)
Process result file -k set/release
560 + (REF + 1) [Figure] 70 + (CHK + 1) [Figure] 70
-k check
700 + (REF + 1) [Figure] 70 + (CHK + 1) [Figure] 70
REF
+ [Figure] (490+ (RCn [Figure] 70)
n=1
GEN ROW
+ [Figure]([Figure](RCnml [Figure] 70)))
m=1 l=1
CHK
+ [Figure](490+ (CCn [Figure] 70)
n=1
GEN ROW
+ [Figure]([Figure](CCnml [Figure] 70)))
m = 1 l = 1

REF: Number of referential constraints defined for the table

CHK: Number of check constraints defined for the table

RC: Number of referential constraint columns containing foreign keys

CC: Number of column in the search condition of check constraint

GEN: 1

ROW: Upper limit of the number of outputs of the key value that caused a constraint error (value specified by the -w option)