NAME

Segment name.

CHAR(8)

NOT NULL

CTIME

Date and time stamp when the segment was created.

TIMESTAMP

NOT NULL

UTIME

Date and time stamp when the segment was last updated.

TIMESTAMP

NOT NULL

CRITTIME

Date and time stamp of the last critical change made to the segment.

TIMESTAMP

NOT NULL

CUSER

ID of the user who created the segment.

CHAR(18)

NOT NULL

UUSER

ID of the user who last updated the segment.

CHAR(18)

NOT NULL

SCHEMA

Name of the SQL schema, if any, that is associated with the segment. If an SQL schema name is associated with the segment, only tables whose names are qualified by the SQL schema name can be stored in areas associated with the segment.

CHAR(18)

NOT NULL

PAGEGROUP

Identifier of the page group that contains the areas associated with the segment.

SMALLINT

NOT NULL

RECSPERPAGE

Maximum number of rows that can be stored on a single page. The value in this column is equal to the value supplied by the user, rounded up to the nearest power of 2, minus 1.

INTEGER

NOT NULL

NUMAREAS

Number of areas associated with the segment.

SMALLINT

NOT NULL

NUMFILES

Number of files associated with the segment.

SMALLINT

NOT NULL

NUMDADS

Number of files associated with this segment that contain dynamic allocation (DAD) information.

SMALLINT

NOT NULL

NUMFILEMAPS

Number of files to which the segment maps.

SMALLINT

NOT NULL

NUMSYMBOLICS

Number of symbolics in the segment.

SMALLINT

NOT NULL

STAMPLEVEL

Data definition stamp level:

• N—No stamp checking
• T—Table stamping
• S—Area stamping

CHAR(1)

NOT NULL

TYPE

Segment type:

• N—Non-SQL segment
• R—SQL (Relational) segment

CHAR(1)

NOT NULL

FILLER

Reserved for future use.

BINARY(40)

NOT NULL