BRMS SQL Services

BRMS is introducing SQL Service interfaces as a new way to view, order, and subset BRMS information.

To enable BRMS SQL services, the supporting IBM i BRMS PTFs needs to be applied first, followed by running this command to install the new services: INZBRM OPTION(*SQLSRVINZ)

Existing user profiles used to perform BRMS operations may require additional authority to allow proper access. Additional authority may be granted using the SETUSRBRM command with the new USAGE(*AUT) parameter option.

NOTE: *SECADM authority is required to use the SETUSRBRM command.

This table contains a summary of services that are available, and which PTF(s) are required for a given service.

5770-BR2 Services

The 5770-BR2 product contains services from the 5770-BR1 product with additional extensions. Queries written for 5770-BR1 will in most instances continue to work with 5770-BR2.

BRMS Service	Description	Type of Service
			5770-BR2
			7.4	7.5
QUSRBRM.MEDIA_INFO	The media info view contains information about a BRMS media object. The values returned for the columns in this view are similar to the values returned by the Work with Media using BRM (WRKMEDBRM) command.	View	Base	Base
QUSRBRM.MEDIA_SET_INFO	The Media_Set_Info table function returns serial media set information. Serial media sets are single or multiple volumes that were created together during a save operation.	Table Function	Base	Base
QUSRBRM.MEDIA_LIBRARY_MEDIA_INFO	The Media_Library_Media_Info procedure returns all media or specific media in a media library device. The information returned is similar to the information returned by the Work with Media Library Media using BRM (WRKMLMBRM) command.	Procedure	Base

BRMS Service	Description	Type of Service	Supported IBM i Releases
			5770-BR2
			7.4	7.5
QUSRBRM.BRMS_LOG_INFO	The media info view contains information about the BRMS Log Information. The values returned for the columns in this view are similar to the values returned by the Display Log for BRM (DSPLOGBRM) command.	View	Base	Base
QUSRBRM.BRMS_DISTRIBUTION_MESSAGES	The distribution messages view shows you the names of the distribution servers, the email address used for the notifications, and the message IDs to email when they are sent to the BRMS log.	View	Base	Base
QUSRBRM.SET_BRMS_DISTRIBUTION_SERVER	The set distribution messages 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.	Procedure	Base	Base
QUSRBRM.ADD_BRMS_DISTRIBUTION_MESSAGE	The add distribution messages procedure sets the message IDs to be notified for when sending email notifications for messages sent to the BRMS log.	Procedure	Base	Base
QUSRBRM.REMOVE_BRMS_DISTRIBUTION_MESSAGE	The remove distribution messages procedure removes message IDs used when sending email notifications about messages sent to the BRMS log.	Procedure	Base	Base
QUSRBRM.BRMS_LOG_OMITS	The log omits view shows you the message IDs the are currently omitted from the BRMS log.	View	Base	Base
QUSRBRM.ADD_BRMS_LOG_OMIT	The add log omits procedure sets the message IDs to be omitted from to the BRMS log.	Procedure	Base	Base
QUSRBRM.REMOVE_BRMS_LOG_OMIT	The remove log omits procedure sets the message IDs to be omitted from to the BRMS log.	Procedure	Base	Base

BRMS Service	Description	Type of Service	Supported IBM i Releases
			5770-BR2
			7.4	7.5
QUSRBRM.MEDIA_LIBRARY_MANAGEMENT_INFO	The media library management view shows the media libraries being managed by the BRMS network. Each media library device can have a user-defined set of systems in the BRMS network assigned to it. This view shows the list of systems assigned to the media library which BRMS will send updates to whenever a media library operation occurs.	View	Base	Base
QUSRBRM.ADD_MEDIA_LIBRARY_MANAGEMENT	The add media library management procedure adds a link to a system in the BRMS network to a media library on the current system so whenever a media library operation occurs on the current system, the same media library on the other system in the BRMS network will be updated.	Procedure	Base	Base
QUSRBRM.REMOVE_MEDIA_LIBRARY_MANAGEMENT	The remove media library management procedure removes a link from a system in the BRMS network to a media library on the current system so whenever a media library operation occurs on the current system, the same media library on the other system in the BRMS network will not be updated.	Procedure	Base	Base

BRMS Service	Description	Type of Service	Supported IBM i Releases
			5770-BR2
			7.4	7.5
QUSRBRM.ENTERPRISE_CONTACT_INFO	The enterprise contact information view users associated with the enterprise hub and nodes.	View	Base	Base
QUSRBRM.ADD_ENTERPRISE_CONTACT	The add enterprise contact procedure adds a contact to BRMS enterprise.	Procedure	Base	Base
QUSRBRM.ADD_ENTERPRISE_NODE	The add enterprise node procedure adds a new system to BRMS enterprise as a node.	Procedure	Base	Base
QUSRBRM.ADD_ENTERPRISE_REPORT_DEFINITION	The add enterprise report definition procedure adds a report definition to BRMS enterprise.	Procedure	Base	Base
QUSRBRM.CHANGE_ENTERPRISE_CONTACT	The change enterprise contact procedure allows you to change the information about a contact in BRMS enterprise.	Procedure	Base	Base
QUSRBRM.CHANGE_ENTERPRISE_HUB	The change enterprise hub procedure allows you to make changes to the enterprise hub.	Procedure	Base	Base
QUSRBRM.CHANGE_ENTERPRISE_NODE	The change enterprise node procedure allows you to change an existing enterprise node.	Procedure	Base	Base
QUSRBRM.CHANGE_ENTERPRISE_REPORT_DEFINITION	The change enterprise change report definition procedure lets you make changes to an existing report definition.	Procedure	Base	Base
QUSRBRM.REMOVE_ENTERPRISE_CONTACT	The remove enterprise contact procedure deletes an enterprise contact.	Procedure	Base	Base
QUSRBRM.REMOVE_ENTERPRISE_NODE	The remove enterprise node procedure allows you to remove an existing enterprise node.	Procedure	Base	Base
QUSRBRM.REMOVE_ENTERPRISE_REPORT_DEFINITION	The remove enterprise report definition procedure removes an existing enterprise report.	Procedure	Base	Base
QUSRBRM.ENTERPRISE_HUB_INFO	The enterprise hub information view shows the settings for the hub system that defines the enterprise network.	View	Base	Base
QUSRBRM.ENTERPRISE_NETWORK_INFO	The enterprise network information view shows the systems and the status information for each system in the BRMS enterprise network.	View	Base	Base
QUSRBRM.ENTERPRISE_NODE_INFO	The enterprise node information view shows you the settings for an individual enterprise node.	View	Base	Base
QUSRBRM.ENTERPRISE_REPORT_DEFINITION_INFO	The enterprise report definition information view shows you the attributes for the current reports defined to run on the enterprise nodes.	View	Base	Base
QUSRBRM.ENTERPRISE_REPORT_OUTPUT	The enterprise report output view shows the results of the reports run on an enterprise node.	View	Base	Base
QUSRBRM.ENTERPRISE_REPORT_STATUS	The enterprise report status view shows the current status of report definitions that are run on an enterprise node.	View	Base	Base
QUSRBRM.RUN_ENTERPRISE_REPORT_DEFINITION	The enterprise report definition procedure is used to run an existing enterprise report definition manually.	Procedure	Base	Base

BRMS Service	Description	Type of Service	Supported IBM i Releases
			5770-BR2
			7.4	7.5
QUSRBRM.NETWORK_INFO	The QUSRBRM.NETWORK_INFO view shows the systems and settings for the BRMS network.	View	Base	Base
QUSRBRM.ADD_NETWORK_SYSTEM	The QUSRBRM.ADD_NETWORK_SYSTEM procedure adds a new system to the BRMS network.	Procedure	Base	Base
QUSRBRM.REMOVE_NETWORK_SYSTEM	The QUSRBRM.REMOVE_NETWORK_SYSTEM procedure removes a system from the BRMS network.	Procedure	Base	Base
QUSRBRM.ACTIVATE_NETWORK_SYSTEM	The QUSRBRM.ACTIVATE_NETWORK_SYSTEM procedure activates a remote system in the BRMS network.	Procedure	Base	Base

5770-BR1 Services

NOTE: A PTF of base indicates that the service is available in the base release without additional PTFs.

IBM Partnership

BRMS SQL Services

5770-BR2 Services

5770-BR1 Services

Related pages