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. 

BRMS Service

Description

Type of Service

Supported IBM i Releases

7.2

7.3

7.4

7.5

Media Services

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

SI73676

 

SI73677

Update:

SI78289

SI73678

Update:

SI78290

Base

Update:

SI78291

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

SI73676

SI73677

SI73678

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

N/A

SI78289

SI78290

SI78291

BRMS Log Services

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

SI74477

SI74478

SI74479

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

N/A

SI78289

SI78290

SI78291

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

N/A

SI78289

SI78290

SI78291

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

N/A

SI78289

SI78290

SI78291

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

N/A

SI78289

SI78290

SI78291

QUSRBRM.BRMS_LOG_OMITS

The log omits view shows you the message IDs the are currently omitted from the BRMS log.

View

N/A

SI78289

SI78290

SI78291

QUSRBRM.ADD_BRMS_LOG_OMIT

The add log omits procedure sets the message IDs to be omitted from to the BRMS log.

Procedure

N/A

SI78289

SI78290

SI78291

QUSRBRM.REMOVE_BRMS_LOG_OMIT

The remove log omits procedure sets the message IDs to be omitted from to the BRMS log.

Procedure

N/A

SI78289

SI78290

SI78291

Backup Services

QUSRBRM.CG_BACKUP_STATUS

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

Base

QUSRBRM.BRMS_CONTROL_GROUP_OMITS

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

QUSRBRM.BRMS_CONTROL_GROUP_IFS_ENTRY

 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

Media Library Services

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

N/A

SI78289

SI78290

SI78291

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

N/A

SI78289

SI78290

SI78291

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

N/A

SI78289

SI78290

SI78291

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