Space estimation formulas

The DASD MANAGER PLUS Space Estimation facility calculates data-set sizing information for Db2 table spaces, table space partitions, and indexes.

This calculation is based on information supplied by the user or by information that exists in the BMCSTATS database, the Db2 catalog, or the Integrated Catalog Facility (ICF) catalog

Important

Space estimation is not available for objects that have partial statistics.

The BMCSTATS batch utility uses the Space Estimation facility to calculate values for the REORGSPACE, REORGSPACE_KB, and REORGNLEVELS columns for table spaces or table space partitions and index spaces or index partitions.

The DASD MANAGER PLUS user interface also allows you to access the Space Estimation facility. You use the online facility like a calculator or spreadsheet, with fill-in-the-blank panels, and the panels display the resulting estimates.


Related topics

Space-estimation-considerations

Space-required-for-partitioned-and-nonsegmented-table-spaces

Space-required-for-universal-table-spaces

Space-required-for-segmented-table-spaces

Space-required-for-partition-by-growth-table-space

Dictionary-pages-by-segment-size-segsize

The Space Estimation facility calculates Db2 object space requirements in both kilobytes and tracks. The tracks estimate depends on the device type for the Db2 object, as the number of kilobytes per track varies across device types.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*