Nonstop Database, HiRDB Version 9 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 if the inner replica facility is not used
If the inner replica facility is used, the number of generations (1 to 10) + 1 in which the replica RDAREA of the table exists

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