Estimating the minimum size of the database

Unless you do not plan to insert segments into your database after it is loaded, allocate more space for your database than you actually estimate for the initial load.

This topic contains the step-by-step procedure for estimating minimum database space. To estimate the minimum size needed for your database, you must already have made certain design decisions about the physical implementation of your database. Because these decisions are different for each DL/I access method, they are discussed under the appropriate access method in step 3 of the procedure.

If you plan to reorganize your HALDB partitions online, consider the extra space reorganization requires. Although online reorganization does not need any additional space when you first load a HALDB partition, the process does require additional space at the time of reorganization.