The following table shows the formulas for determining the file sizes required for the execution of the optimizing information collection utility (pdgetcst):
File type | Formula (bytes) |
---|
Parameter file that contains optimized information | 162 + 405 x a + 567 x b + 162 + 324 x b x g |
Output results file | - Collecting optimizing information by retrieval (-c lvl1 specified):
202 + 131 x e
- Collecting optimizing information by retrieval (-c lvl2 specified):
370 + 561 x d + 196 x d
- Registering optimizing information using the parameter file that contains optimized information:
370 + 235 x c + 387 x f + 196 x g |
- a: Number of specified indexes
- b: Number of specified columns
- c: Number of indexes defined in table
- d: Number of intervals (total of number of sectors for all indexes)
- e: Number of tables
- f: Number of columns in table
- g: Number of sectors (total of number of sectors specified in all column definitions)