SEGMENT

Segment name.

CHAR(8)

NOT NULL

NAME

Area name.

CHAR(18)

NOT NULL

CTIME

Date and time when the area was created.

TIMESTAMP

NOT NULL

UTIME

Date and time when the area was last updated.

TIMESTAMP

NOT NULL

CRITTIME

Date and time of the last critical change to the area.

TIMESTAMP

NOT NULL

TIMESTAMP

Definition date/time stamp for table validation.

TIMESTAMP

NOT NULL

CUSER

User ID of user who created the area.

TIMESTAMP

NOT NULL

UUSER

User ID of user who last updated the area.

CHAR(18)

NOT NULL

TYPE

Area type:

• N—Non-SQL area
• R—SQL area

CHAR(1)

NOT NULL

STAMPLEVEL

Stamp indicator:

• N—No stamp checking for a non-SQL area
• T—Table-level stamping for an SQL area
• S—Area-level stamping for an SQL area

CHAR(1)

NOT NULL

NUMFILEMAPS

Number of filemaps in the area.

SMALLINT

NOT NULL

NUMSYMBOLICS

Number of symbolics in the area.

SMALLINT

NOT NULL

DISPLACEMENT

Cluster displacement.

SMALLINT

NOT NULL

PAGEGROUP

The page group associated with the area.

SMALLINT

NOT NULL

LOWPAGE

Low page number of the area.

INTEGER

NOT NULL

HIGHPAGE

High page number of the area.

INTEGER

NOT NULL

CALCHIGHPAGE

Primary (calc) high page number of the area.

INTEGER

NOT NULL

MAXHIGHPAGE

Maximum high page number of the area.

INTEGER

NOT NULL

NUMPAGES

Number of pages

INTEGER

NOT NULL

PAGESIZE

Size, in bytes, of each page in the area.

INTEGER

NOT NULL

PAGERESERVE

Page reserve size, in bytes. This column indicates the number of bytes left unused on a page when new rows are stored so that space is available for the expansion of variable-length rows during update operations.

INTEGER

NOT NULL

ORIGPAGESIZE

Original page size of the area.

INTEGER

NOT NULL

NUMPAGESUSED

Number of nonempty pages in the area.

INTEGER

NOT NULL

NUMROWS

Number of rows in the area.

INTEGER

NOT NULL

PCTSPACEUSED

Percent of space used in the area.

REAL

NOT NULL

FILLER

Reserved for future use.

BINARY(40)

NOT NULL