Example:
SELECT MESSAGE_ID FROM QUSRBRM.BRMS_LOG_OMITS

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 :
 

SELECT * FROM TABLE(QUSRBRM.MEDIA_SET_INFO('000013'))

MEDIA_LIBRARY_INFO view returns information that can also be seen through the Work with Media Library Status (WRKMLBSTS) command interface

also QUSRBRM / CG_BACKUP_STATUS

source for this view is

source for this view is QUSRBRM / QA1ALG

DSPLOGBRM