QUSRBRM.SET_BRMS_DISTRIBUTION_SERVER Procedure

Owned by Peter Lafler
Last updated: Jul 19, 2023 by Aaron Fistler
3 min read

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

QUSRBRM.SET_BRMS_DISTRIBUTION_SERVER (PRIMARY_SERVER=> primary-server, SECONDARY_SERVER => secondary-server, EMAIL_ADDRESS => email-address)

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:

  • No validity checking is performed on the email address.

  • Multiple email addresses are supported when separated by a comma.

 

 

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')

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')

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

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.

 

 

Privacy Policy | Cookie Policy | Impressum
From time to time, this website may contain technical inaccuracies and we do not warrant the accuracy of any posted information.
Copyright © Fortra, LLC and its group of companies. All trademarks and registered trademarks are the property of their respective owners.