Nonstop Database, HiRDB Version 9 Installation and Design Guide

[Contents][Index][Back][Next]

14.2 Segments

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

Table 14-3 Segment statuses

Segment status Explanation
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 used segment that is not full is called a non-full segment.
A used 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 This is a segment that has never been used. Such a segment can be used by all tables (or indexes) in the RDAREA.
Free segment This 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