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 |