By executing the free page release utility, you can convert used free segments to unused segments and reuse them. This is called releasing used free segments. Figure 15-4 provides an overview of releasing used free segments.
Figure 15-4 Releasing used free segments
Once segments are allocated, only the table (or index) that is assigned to use a particular segment can use it; no other tables can do so. Releasing used free segments converts used free segments to unused segments, which enables other tables to use those segments.
Whether or not to release used free segments is determined from the execution results of the free page release utility or the database condition analysis utility. Release used free segments if there are a large number of them.
Because updated logs of the database are obtained when used free segments are released, we recommend that you re-estimate the system log file capacity. For details about estimating system log file capacity, see the manual HiRDB Version 8 Installation and Design Guide.
You use the free page release utility to release used free segments. Check the execution results of the free page release utility to determine if used free segment have been released as expected.
If the free page release utility terminates abnormally, the system returns to its status before the utility was executed (before any operation was performed). In such a case, simply re-execute the free page release utility. Although not re-executing the free page release utility does not create a problem, no used free segments are released if you do not re-execute.