Scalable Database Server, HiRDB Version 8 Installation and Design Guide
The free space reusage facility uses the free space on used pages by switching the page search mode to the free page reuse mode once the number of a table's used segments reaches the number of user-specified segments and those segments have all become full. If there is no free space in any of the specified number of segments, it switches to the new page allocation mode for allocation of a new unused segment.
If the number of segments is not specified, free space is not reused until there are no more unused pages in an RDAREA. When the free space reusage facility is not used, free space is searched for each time from the beginning of the used segments. When the facility is used, the search efficiency is better than when it is not used, because after switching to the free page reuse mode the first time, the search start position is remembered for the subsequent search.
Figure 15-4 provides an overview of the free space reusage facility.
Figure 15-4 Overview of the free space reusage facility
All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.