QUSRBRM.SET_BRMS_DISTRIBUTION_SERVER Procedure
The QUSRBRM.SET_BRMS_DISTRIBUTION_SERVER procedure sets the primary and secondary distribution server, and the distribution email address to use when sending email notifications for messages sent to the BRMS log.
Parameters
|
primary-server
Specifies the primary server to be used for distributions from the current system.
Possible values are:
NONE | Specifies all distribution activity is suspended for the current system. |
LOCAL | Specifies the current system is to perform the distribution. |
SAME | Specifies that you are not changing the primary server. The value will be left the same. |
server-name | Specifies the primary server name to be used to provide primary distribution services for the current system. The server name is in the form nnnnnnnn.ssssssss where nnnnnnnn is the network ID and ssssssss is the system name. |
secondary-server
Specifies the secondary server to be used for distributions from the current system. The current system will attempt to use the secondary server if communications with the primary server cannot be established.
Possible values are:
NONE | Specifies no secondary distribution server is to be used. |
LOCAL | Specifies the current system is to perform the secondary distribution. |
SAME | Specifies that you are not changing the secondary server. The value will be left the same. |
server-name | Specifies the secondary server name to be used to provide primary distribution services for the current system. The server name is in the form nnnnnnnn.ssssssss where nnnnnnnn is the network ID and ssssssss is the system name. |
email-address
Specifies the email address used to distribute email from the current system.
Possible value are:
NONE | Email distributions are disabled on the current system. Note: This value does not affect this system from being a distribution server for other systems in the BRMS network. |
SAME | Specifies that you are not changing the email address. The value will be left the same. |
email-address | The email address to be used to distribute email from the current system. This is the distribution email address where the notification messages are sent. The maximum length of the email addresses is 256 characters. Note:
|
Authorization: The privileges held by the authorization ID of the statement must include the following:
*EXECUTE SQL privilege on this procedure
The BRMS Network feature is required.
The schema is QUSRBRM.
Examples
call QUSRBRM.SET_BRMS_DISTRIBUTION_SERVER('APPN.PRIMARY', 'none', 'myemail@company.com') |
|---|
Multiple email addresses may be specified using comma separated entries.
call QUSRBRM.SET_BRMS_DISTRIBUTION_SERVER('APPN.PRIMARY', 'none', ' 'myemail1@company.com, myemail2@company.com, myemail3@company.com') |
|---|
Error Messages
The following error SQLSTATEs may be returned by this procedure.
Msg ID | Error |
|---|---|
U0001 | Invalid input data. One of the following specific message texts: Primary server is not valid. Secondary server is not valid. Primary server is not valid, Secondary server is not valid. |
U0002 | Unable to retrieve System Policy record. |
U0003 | Unable to update System Policy record. |
U9999 | Illegal execution. |
NOTES:
The system that you set as the primary distribution server will distribute the messages. If the primary distribution server cannot complete the distribution, it sends the message to the secondary distribution server for distribution. For example, you could select a local primary distribution server and a remote secondary distribution server. When the local server is in restricted state, BRMS sends the email through the remote secondary server. If a secondary server is not specified and the primary server is in restricted state, the message will be queued and distributed as soon as the BRMS networking is restarted.
The email server must have the Simple Mail Transport Protocol (SMTP) configured. If it is not configured, messages will not get distributed and an error message may not result.
If the primary server is in a restricted state, and Using TCP/IP in Restricted State is setup and started, then BRMS will distribute the messages via the secondary server, providing all requirements are met.
If the primary server is not started prior to the failure, the messages will not be sent via the secondary system.
Copyright © Fortra, LLC and its group of companies. All trademarks and registered trademarks are the property of their respective owners.