Page Comparison

Column Name

System Column Name

Data Type

Description

MESSAGE_ID

MSGID

VARCHAR(7)

The message identifier of the message which issued.

MESSAGE_SEVERITY

SEVERITY

SMALLINT

The message severity assigned to the message.

JOB_NAME

JOB_NAME

VARCHAR(10)

The name of the job when the message was issued.

JOB_USER

JOB_USER

VARCHAR(10)

The userid of the job when the message was issued.

QUALIFIED_JOB_NAME

QUAL_JOB

VARCHAR(28)

The qualified name of the job when the message was issued.

MESSAGE_TIMESTAMP

MSG_TIME

TIMESTAMP

The timestamp for when the message was issued. 

MESSAGE_PROGRAM

MSG_PGM

VARCHAR(10)

The program or service program that issued the message.

AREA

AREA

VARCHAR(11)

Nullable

Indicates the BRMS functional area where the message originated.            

The possible values are:

ARCHIVE The log entry is from the BRMS archive process.

BACKUP The log entry is from the BRMS backup process. 

ENTERPRISE The log entry is from the BRMS enterprise function.

MAINTENANCE The log entry is from the BRMS maintenance function.

MEDIA The log entry is from the BRMS media function.

MIGRATION The log entry is from the BRMS migration function.

RECOVERY The log entry is from the BRMS recovery function.

RETRIEVE The log entry is from the BRMS dynamic retrieve function.

SECURITY The log entry is from the BRMS security related function.      

Contains the null value if area has not been set.

CONTROL_GROUP

CGNAME

VARCHAR(10)

Nullable

The name of the BRMS control group associated with the message.

Contains the null value if the message was not sent during BRMS control group processing.

MESSAGE_TEXT

MSG_TEXT

VARGRAPHIC(1024)

CCSID 1200

The first level text of the message.

MESSAGE_SECOND_LEVEL_TEXT

MSG_TEXT2

VARGRAPHIC(4096) CCSID 1200

Nullable

The second level text of the message.

Contains the null value if no second-level text is defined.