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 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:
|
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:
|
EMAIL_ADDRESS | EMAILADDR | VARGRAPHIC(256) | 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:
|
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 |
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 |