Previous Topic: SYSTEM.DMCLFILENext Topic: SYSTEM.FILE


SYSTEM.DMCLSEGMENT

Description

A row of SYSTEM.DMCLSEGMENT contains information about a segment definition and a DMCL where the segment has been included. DMCLSEGMENT contains information specific to the DMCL where the segment has been included.

Column name

Column description

Data type

Null specifi- cation

DMCL

DMCL name.

CHAR(8)

NOT NULL

NAME

Segment name.

CHAR(8)

NOT NULL

CTIME

Date and time when the segment was created.

TIMESTAMP

NOT NULL

UTIME

Date and time when the segment was last updated.

TIMESTAMP

NOT NULL

CRITTIME

Date and time 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

BUFFER

Name of the buffer within the DMCL which is the default for all files defined within the segment unless specifically overridden.

CHAR(18)

NOT NULL

STARTUP

Startup indicator. This indicates the READY action to be taken when the system is started following an orderly shutdown. Values are:

  • U—Update
  • R—Retrieval
  • T—Transient retrieval
  • X—Set status offline

CHAR(1)

NOT NULL

WARMSTART

Warmstart indicator. This indicates the READY action to be taken when the system is started following an abnormal termination. Values are:

  • U—Update
  • R—Retrieval
  • T—Transient retrieval
  • X—Set status offline
  • C—Maintain current status

CHAR(1)

NOT NULL

DATASHARE

Data sharing indicator.

  • 'Y' - all areas in the segment are eligible to be shared for update
  • 'N' - no areas in the segment are shared

CHAR(1)

NOT NULL

SHAREDCACHE

Default shared cache.

CHAR(16)

NOT NULL

FILLER

Reserved for future use.

CHAR(23)

NOT NULL