The QUSRBRM.BRMS_DISTRIBUTION_MESSAGES view shows you the names of the distribution servers, the email address used for the notifications, and the message IDs sent to the BRMS log.

Authorization:

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

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

The BRMS Network feature is required.

Result Table

The following table describes the columns in the view. The system name is DIST_MSGS. The schema is QUSRBRM.

Column Name	System Column Name	Data Type	Description
PRIMARY_SERVER	PRIMARY	VARCHAR(17)	The primary server name to be used for distribution services for the current system. The possible values are: NONE Distribution activity is suspended for the current system. LOCAL The current system is used to perform the distribution. server-name The server name in the format nnnnnnnn.ssssssss where nnnnnnnn is the network identifier and ssssssss is the local location name.
SECONDARY_SERVER	SECONDARY	VARCHAR(17)	The secondary server to be used for distribution services for the current system. The current system will attempt to use the secondary server if communications with the primary server cannot be established. The possible values are: NONE No secondary distribution server is to be used. LOCAL The current system is used to perform the secondary distribution. server-name The server name in the format nnnnnnnn.ssssssss where nnnnnnnn is the network identifier and ssssssss is the local location name.
EMAIL_ADDRESS	EMAILADDR	VARGRAPHIC(256) CCSID 1200	The email address to be used to distribute email from the current system. The maximum length of the email address is 256 characters. The possible values are: NONE Email distributions are disabled on the current system. email-address The email address to be used to distribute email from the current system.
MESSAGE_ID	MSGID	VARCHAR(7)	The messaged ID to distribute when sending email notifications for messages sent to the BRMS log.

Examples

Example 1- Report what the current distribution message setup:

SELECT DISTINCT PRIMARY_SERVER, SECONDARY_SERVER, EMAIL_ADDRESS FROM QUSRBRM.BRMS_DISTRIBUTION_MESSAGES

Example output:

PRIMARY_SERVER	SECONDARY_SERVER	EMAIL_ADDRESS
LOCAL	NONE	email.address@company.com

Example 2- Report the message identifiers that are set up to be distributed:

SELECT MESSAGE_ID FROM QUSRBRM.BRMS_DISTRIBUTION_MESSAGES

Example output:

MESSAGE_ID

BRM1049

BRM10A1

BRM10A2

BRM402A

IBM Partnership

QUSRBRM.BRMS_DISTRIBUTION_MESSAGES View

Examples

Example 1- Report what the current distribution message setup:

Example 2- Report the message identifiers that are set up to be distributed: