QUSRBRM.BRMS_LOG_INFO View

The BRMS_LOG_INFO view contains information about messages logged during BRMS operations.

The values returned for the columns in this view are similar to the values returned by the Display BRM Log Information (DSPLOGBRM) command.

Authorization:

The authorization ID of the statement must include the following privileges:

*OBJOPR and *READ authority to the QUSRBRM/LOG_INFO object.

The system name is LOG_INFO. The schema is QUSRBRM.

The following table describes the columns in the view.

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.

Example 1 : Return BRMS log information for job 468928/QUSER/QBRMBKUP.

SELECT * FROM QUSRBRM.BRMS_LOG_INFO WHERE QUALIFIED_JOB_NAME = '468928/QUSER/QBRMBKUP'