Previous Topic: SYSTEM.DMCLNext Topic: SYSTEM.DMCLFILE


SYSTEM.DMCLAREA

Description

A row of SYSTEM.DMCLAREA contains information about an area whose segment has been included in the DMCL.

Column name

Column description

Data type

Null specifi- cation

DMCL

DMCL name.

CHAR(8)

NOT NULL

SEGMENT

Name of the segment that contains the area.

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 made to the area.

TIMESTAMP

NOT NULL

CUSER

ID of the user who created the area.

CHAR(18)

NOT NULL

UUSER

ID of the user who last updated the area.

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

PAGERESERVE

Page reserve. Number of bytes to be left unused on a page when new rows are stored on pages in the area. For this DMCL, the page reserve specification overrides the page reserve specification in the segment's area definition.

INTEGER

NOT NULL

DATASHARE

Data sharing indicator.

  • 'Y' - the area is eligible to be shared for update
  • 'N' - the area is not shared
  • 'D' - the area's sharability is determined by that of its segment

CHAR(1)

NOT NULL

FILLER

Reserved for future use.

CHAR(39)

NOT NULL