14.2 Segments

The following table lists the statuses that a segment can have.

Table 14-3 Segment statuses

Segment statusExplanation
Used segment#This is a segment that stores table or index data. A segment that is full, such that no more data can be added, is called a full segment. A segment from which all the data has been deleted, such that all pages are free pages (used free pages or unused pages), is called a used free segment.
Unused segmentThis is a segment that has never been used. Such a segment can be used by all tables (or indexes) in the RDAREA.
Free segmentThis is a segment that does not store any data. Used free segments and unused segments are free segments.
#: Used segments can be used only by tables or indexes that have data stored in them. Other tables or indexes cannot use such segments.
Organization of this section
14.2.1 Determining the segment size
14.2.2 Setting the percentage of free pages in a segment
14.2.3 Allocating and releasing segments