15.2 Segments

Table 15-3 shows the various segments statuses.

Table 15-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
15.2.1 Determining the segment size
15.2.2 Setting the percentage of free pages in a segment
15.2.3 Allocating and releasing segments