20.1.7 File sizes required for the execution of the optimizing information collection utility (pdgetcst)

The following table shows the formulas for determining the file sizes required for the execution of the optimizing information collection utility (pdgetcst):

File typeFormula (bytes)
Parameter file that contains optimized information162 + 405 [Figure] a + 567 [Figure] b
Output results file
Collecting optimizing information by retrieval (-c lvl1 specified):
202 + 131 [Figure] e
Collecting optimizing information by retrieval (-c lvl2 specified):
370 + 561 [Figure] d + 196 [Figure] d
Registering optimizing information using the parameter file that contains optimized information:
370 + 235 [Figure] c + 387 [Figure] f
a: Number of specified indexes
b: Number of specified columns
c: Number of indexes defined in table
d: Number of intervals
e: Number of tables
f: Number of columns in table