QUSRBRM / MEDIA_LIBRARY_MEDIA_INFO (Procedure)

By kimot, 30 December, 2022 
BRMS - Medial Library Info

Parameters : 
QUSRBRM.MEDIA_LIBRARY_MEDIA_INFO (MEDIA_LIBRARY => media-library, VOLUME_ID => volume-id, CATEGORY => category, BRM_VOLUME => brm-volume, MEDIA_CLASS => media-class, BRMS_STATUS => brms-status) 
 

category : *ALL / *EJECT / *INSERT / *IPL / *NL (non labeled)/*NOSHARE / *SHARE400 
brm-volume : *ANY / *NO (non-BRMS) / *YES (BRMS)
media-class : *ALL / media-class-name
brms-status : *ALL / *ACT / *ERR / *EXP / *INZ



Error messages returned by this procedure :
 

U0001Media library &1 not found or not defined
U0002Category not valid for parameter CGY
or
Category does not exists
U0003BRMS volume not valid
U0004Media class &1 not found
U0005BRMS Status not valid
U9999Illegal execution


Example - show all expired media in media library TAPMLBXX
CALL QUSRBRM.MEDIA_LIBRARY_MEDIA_INFO ('TAPMLBXX', '*ALL', '*ALL', '*ANY', '*ALL', '*EXP')

 

Fields

for OPTICAL devices

Field         Type       Length  Text
VOLUME_ID     VARCHAR        32  Volume Identifier
VOLUME_SERIAL VARCHAR         6  Volume Serial
VOLUME_TYPE   VARCHAR        12  Volume Type
MEDIA_TYPE    VARCHAR         8  Optical Media Type
MEDIA_CLASS   VARCHAR        10  BRMS Media Class
BRMS_STATUS   VARCHAR         4  BRMS Tape Status

 

for TAPE devices

Field       Type       Length  Text 
VOLUME_ID   VARCHAR         6  Volume Identifier
MEDIA_TYPE  VARCHAR         2  Media Type
CATEGORY    VARCHAR        10  Tape Category
STATUS      VARCHAR        28  Tape Status
MEDIA_CLASS VARCHAR        10  BRMS Media Class
BRMS_STATUS VARCHAR         4  BRMS Tape Status