QUSRBRM.MEDIA_LIBRARY_MANAGEMENT_INFO View

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:

Column Name

System Column Name

Data Type

Description

LIBRARY_DEVICE

DEVICE

VARCHAR(10)

The media library device name.

SYSTEM

SYSTEM

VARCHAR(17)

The system name linked to the media library on the current system.

Note: The system name is in the form nnnnnnnn.ssssssss where nnnnnnnn is the network ID and ssssssss is the system name. 

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:

LIBRARY_DEVICE

SYSTEM

TAPMLB01

APPN.SYSTEM1

TAPMLB01

APPN.SYSTEM2

TAPMLB01

APPN.SYSTEM3

TAPMLB01

APPN.SYSTEM4

 

Copyright © Fortra, LLC and its group of companies. All trademarks and registered trademarks are the property of their respective owners.