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 | |||
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 | SI73678 | |
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 | |
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 | |
Backup Status 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 |