Before reading about reusing used free pages and used free segments in this section, you must be familiar with page statuses and segment statuses. Table 15-7 Page statuses lists and describes pages statuses, and Table 15-8 Segment statuses lists and describes segment statuses.

Table 15-7 Page statuses

Page status	Description
Unused page	A page that has not been allocated.
Used free page	A page in which no data is stored as a result of data deletion#.
Used page	A page that stores data and has a free area to which data can be added. In a table that uses the free space reusage facility, a used page includes a page to which data could not be added because the free area inside the page was unavailable due to data deletion#.
Used full page	A page that stores data and does not have a free area to which data can be added. In a table or index that does not use the free space reusage facility, a used full page includes a page to which data could not be added because the free area inside the page was unavailable due to data deletion#.

#

A free area created by data deletion cannot be used until the transaction that executed the data deletion is committed.

Table 15-8 Segment statuses

Segment status	Description
Used segment#	A segment in which table or index data is stored. A used segment that is completely filled with data so that no more data can be added is called a full segment. Any other used segment is called a space-available segment. A space-available segment from which data has been deleted so that only free pages remain (used free pages or unused pages) is called a used free segment.
Unused segment	A segment that is not being used. This segment can be used by any table or index in the RDAREA.
Free segment	A segment in which no data is stored. Both used free segments and unused segments are called free segments.

#: A used segment can be used only by a table or an index that stored data in it. Other tables or indexes cannot use such a segment.