The QUSRBRM.MEDIA_LIBRARY_MANAGEMENT_INFO 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.

Authorization:  

The authorization ID of the statement must include the following privileges:

• *OBJOPR and *READ authority to the QUSRBRM/MLM_INFO object.

The system name is MLM_INFO. The schema is QUSRBRM.

Result Table

The following Table describes the columns in the view:

Example

Report the systems linked to the media library device TAPMLB01:

SELECT LIBRARY_DEVICE, SYSTEM FROM QUSRBRM.MEDIA_LIBRARY_MANAGEMENT_INFO WHERE LIBRARY_DEVICE = 'TAPMLB01'

Example output: