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

Parameters

QUSRBRM.REMOVE_MEDIA_LIBRARY_MANAGEMENT (MEDIA_LIBRARY=> media-library, SERVER => server)

media-library

Specifies the media library name from the current system.

Possible values are:

media-library

Specifies the media library name.

server

Specifies the server to be unlinked from the media library on the current system.

Possible values are:

ALL	Specifies that all servers in the BRMS network will be unlinked from the media library on the current system.
server	Specifies the server name to be unlinked from the media library on the current system. The server name is in the form nnnnnnnn.ssssssss where nnnnnnnn is the network ID and ssssssss is the system name.

Authorization: The privileges held by the authorization ID of the statement must include the following:

*EXECUTE SQL privilege on this procedure

The BRMS Network feature is required.

The schema is QUSRBRM.

Examples

To disable support for library device name TAPMLB01 on system APPN.SYSTEM1:

call QUSRBRM.REMOVE_MEDIA_LIBRARY_MANAGEMENT('TAPMLB01', 'APPN.SYSTEM1')

call QUSRBRM.REMOVE_MEDIA_LIBRARY_MANAGEMENT('TAPMLB01', 'APPN.SYSTEM1')

To disable support for library device name TAPMLB03 for all the systems in the BRMS network:

call QUSRBRM.REMOVE_MEDIA_LIBRARY_MANAGEMENT('TAPMLB03', 'ALL')

call QUSRBRM.REMOVE_MEDIA_LIBRARY_MANAGEMENT('TAPMLB03', 'ALL')

Error Messages

The following error SQLSTATEs may be returned by this procedure.

U0001	Device not valid.
U0002	Server not valid.
U0003	Entry not added.
U0004	Not all systems removed.
U0005	No systems removed.
U9999	Illegal execution.

IBM Partnership

QUSRBRM.REMOVE_MEDIA_LIBRARY_MANAGEMENT Procedure

Parameters

Examples

Error Messages