The following table shows the formulas for determining the memory size required for the execution of the optimizing information collection utility (pdgetcst).
Condition | Formula for determining memory size (KB) | |
---|---|---|
HiRDB/Single Server | 6,060 + 0.1 x number of table storage RDAREAs + 0.07 x number of index storage RDAREAs + 1.0 x number of indexes + 0.04 x number of tables in schema + 1.0 x number of servers + 11 x number of columns | |
HiRDB/Parallel Server | BES | 1,813 + 0.06 x number of table storage RDAREAs + 0.05 x number of index storage RDAREAs + 0.03 x number of indexes |
MGR | 3,336 + 0.1 x number of table storage RDAREAs + 0.07 x number of index storage RDAREAs + 1.0 x number of indexes + 0.04 x number of tables in schema + 1.0 x number of servers + 11 x number of columns | |
DS | 16,402 |
SELECT internal-information#, index-first-configuration-column-name FROM authorization-identifier, table-identifier ORDER BY primary-index-component-column-name WITHOUT LOCK NOWAIT;