Estimating Space Requirements Using the Disk Usage Utility

This procedure will help you determine the space requirements for a table in your product line.

To determine space requirements

Run the ibmdu utility in either online or offline mode to determine your current space requirements.

Note: The tables you change will depend on your site requirements.
Change the values of the initial number of records for your tables by using the File Size Definition form in dbdef.
Run the blddbdict utility to generate a new +dictionary.

Note: Running ibmdu in online mode (rather than offline mode) here will be more accurate because it uses the actual extent and page sizes instead of the default values.
Run the ibmdu utility again using the +dictionary as input to determine your new space requirements.
Repeat steps 2-4 until your sizing is complete.
Type the following to implement your file size changes. At the command, type

dbreorg -g [filename...]