BRMS SQL Services
- Peter Lafler
- Aaron Fistler
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.Â
BRMS Service | Description | Type of Service | Supported IBM i Releases | |||||
|---|---|---|---|---|---|---|---|---|
5770-BR1 | 5770-BR2 | |||||||
7.2 | 7.3 | 7.4 | 7.5 | 7.4 | 7.5 | |||
Media Services | ||||||||
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 | SI73676  | SI73677 Update: SI78289 | SI73678 Update: SI78290 | Base Update: SI78291 | Base | Base | |
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 | SI73676 | SI73677 | SI73678 | Base | Base | Base | |
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 | N/A | SI78289 | SI78290 | SI78291 | Base | Base | |
BRMS Log Services | Â | Â | ||||||
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 | SI74477 | SI74478 | SI74479 | Base | Base | Base | |
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 | N/A | SI78289 | SI78290 | SI78291 | Base | Base | |
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 | N/A | SI78289 | SI78290 | SI78291 | Base | Base | |
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 | N/A | SI78289 | SI78290 | SI78291 | Base | Base | |
The remove distribution messages procedure removes message IDs used when sending email notifications about messages sent to the BRMS log. | Procedure | N/A | SI78289 | SI78290 | SI78291 | Base | Base | |
The log omits view shows you the message IDs the are currently omitted from the BRMS log. | View | N/A | SI78289 | SI78290 | SI78291 | Base | Base | |
The add log omits procedure sets the message IDs to be omitted from to the BRMS log. | Procedure | N/A | SI78289 | SI78290 | SI78291 | Base | Base | |
The remove log omits procedure sets the message IDs to be omitted from to the BRMS log. | Procedure | N/A | SI78289 | SI78290 | SI78291 | Base | Base | |
Backup Services | Â | Â | ||||||
The control group backup status view contains information about BRMS Control Group backup status. The values returned for the columns in this view are similar to the values returned by the BRMS Enterprise function in the Navigator for i. | View | N/A | SI77381 | SI77382 Update: SJ01196 | Base Update: SJ01197 | Base Update: SJ00271 | Base Update: SJ00272 | |
The control group omits view shows global library omits, object omits, or object list omits that have been set up for items in a control group. | View | N/A | SI78289 | SI78290 | SI78291 | Base | Base | |
 The control group IFS entry view shows IFS and link list entry items set up in a control group. | View | N/A | SI78289 | SI78290 | SI78291 | Base | Base | |
Media Library Services | Â | Â | ||||||
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 | N/A | SI78289 | SI78290 | SI78291 | Base | Base | |
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 | N/A | SI78289 | SI78290 | SI78291 | Base | Base | |
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 | N/A | SI78289 | SI78290 | SI78291 | Base | Base | |
BRMS Enterprise Services | Â | Â | ||||||
The enterprise contact information view users associated with the enterprise hub and nodes. | View | N/A | SI80271 | SI80272 | SI80273 | Base | Base | |
The add enterprise contact procedure adds a contact to BRMS enterprise. | Procedure | N/A | SI80271 | SI80272 | SI80273 | Base | Base | |
The add enterprise node procedure adds a new system to BRMS enterprise as a node. | Procedure | N/A | SI80271 | SI80272 | SI80273 | Base | Base | |
The add enterprise report definition procedure adds a report definition to BRMS enterprise. | Procedure | N/A | SI80271 | SI80272 | SI80273 | Base | Base | |
The change enterprise contact procedure allows you to change the information about a contact in BRMS enterprise. | Procedure | N/A | SI80271 | SI80272 | SI80273 | Base | Base | |
The change enterprise hub procedure allows you to make changes to the enterprise hub. | Procedure | N/A | SI80271 | SI80272 | SI80273 | Base | Base | |
The change enterprise node procedure allows you to change an existing enterprise node. | Procedure | N/A | SI80271 | SI80272 | SI80273 | Base | Base | |
The change enterprise change report definition procedure lets you make changes to an existing report definition. | Procedure | N/A | SI80271 | SI80272 | SI80273 | Base | Base | |
The remove enterprise contact procedure deletes an enterprise contact. | Procedure | N/A | SI80271 | SI80272 | SI80273 | Base | Base | |
The remove enterprise node procedure allows you to remove an existing enterprise node. | Procedure | N/A | SI80271 | SI80272 | SI80273 | Base | Base | |
The remove enterprise report definition procedure removes an existing enterprise report. | Procedure | N/A | SI80271 | SI80272 | SI80273 | Base | Base | |
The enterprise hub information view shows the settings for the hub system that defines the enterprise network. | View | N/A | SI80271 | SI80272 | SI80273 | Base | Base | |
The enterprise network information view shows the systems and the status information for each system in the BRMS enterprise network. | View | N/A | SI80271 | SI80272 | SI80273 | Base | Base | |
The enterprise node information view shows you the settings for an individual enterprise node. | View | N/A | SI80271 | SI80272 | SI80273 | Base | Base | |
The enterprise report definition information view shows you the attributes for the current reports defined to run on the enterprise nodes. | View | N/A | SI80271 | SI80272 | SI80273 | Base | Base | |
The enterprise report output view shows the results of the reports run on an enterprise node. | View | N/A | SI80271 | SI80272 | SI80273 | Base | Base | |
The enterprise report status view shows the current status of report definitions that are run on an enterprise node. | View | N/A | SI80271 | SI80272 | SI80273 | Base | Base | |
The enterprise report definition procedure is used to run an existing enterprise report definition manually. | Procedure | N/A | SI80271 | SI80272 | SI80273 | Base | Base | |
BRMS Network Services | Â | Â | ||||||
The QUSRBRM.NETWORK_INFO view shows the systems and settings for the BRMS network. | View | N/A | SI82232 | SI82233 | SI82234 | Base | Base | |
The QUSRBRM.ADD_NETWORK_SYSTEM procedure adds a new system to the BRMS network. | Procedure | N/A | SI82232 | SI82233 | SI82234 | Base | Base | |
The QUSRBRM.REMOVE_NETWORK_SYSTEM procedure removes a system from the BRMS network. | Procedure | N/A | SI82232 | SI82233 | SI82234 | Base | Base | |
The QUSRBRM.ACTIVATE_NETWORK_SYSTEM procedure activates a remote system in the BRMS network. | Procedure | N/A | SI82232 | SI82233 | SI82234 | Base | Base | |
Maintenance Policy Services | Â | Â | ||||||
The QUSRBRM.MAINTENANCE_POLICY view returns a single row that shows the settings to be used when STRMNTBRM is run by a control group backup. | View | N/A | SI82232 | SI82233 | SI82234 | Base | Base | |
The QUSRBRM.CHANGE_MAINTENANCE_POLICY procedure allows you to change the maintenance policy. | Procedure | N/A | SI82232 | SI82233 | SI82234 | Base | Base | |
The QUSRBRM.RESET_MAINTENANCE_POLICY_DEFAULTS procedure changes the maintenance policy back to its original default values. | Procedure | N/A | SI82232 | SI82233 | SI82234 | Base | Base | |
Control Group Service | Â | Â | ||||||
The QUSRBRM.COPY_CONTROL_GROUP procedure copies an existing control group. Use this procedure to copy a backup control group to create a new backup control group. You can assign a new name to the control group that you are creating. You can also copy the control group to a remote system when the Network feature is installed by specifying a system name. | Procedure | N/A | SI82232 | SI82233 | SI82234 | Base | Base | |
Synchronization Environment | Â | Â | ||||||
The QUSRBRM.HISTORY_SYNC view shows the systems that are sending backup history to the current system. | View | N/A | SI83108 | SI83109 | SI83110 | Base | Base | |
The QUSRBRM.ADD_HISTORY_SYNC procedure allows you to add history syncing between systems. | Procedure | N/A | SI83108 | SI83109 | SI83110 | Base | Base | |
The QUSRBRM.REMOVE_HISTORY_SYNC procedure allows you to remove history syncing between systems. | Procedure | N/A | SI83108 | SI83109 | SI83110 | Base | Base | |
Functional Authority Information | Â | Â | ||||||
The QUSRBRM.FUNCTIONAL_AUTHORITY_INFO view shows functional authority information for BRMS functions. | View | N/A | N/A | N/A | SI84133 | Base | Base | |
NOTE: A PTF of base indicates that the service is available in the base release without additional PTFs.
Â
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.