BRMS - Media Set Information
SELECT * FROM TABLE(QUSRBRM.MEDIA_SET_INFO('000013'))
Fields
Field Type Length Text VOLUME_SERIAL VARCHAR 6 Volume Serial VOLUME_IDENTIFIER VARCHAR 32 Volume Identifier (Optical Volume) SEQUENCE INTEGER Volume Sequence Number in Set VOLUME_STATUS VARCHAR 10 Current State of Volume MEDIA_CLASS VARCHAR 10 Media Class Name EXPIRATION VARCHAR 8 When Volume Expires EXPIRATION_DATE DATE 4 Expiration Date LOCATION VARCHAR 10 Current Storage Location MOVE DATE 4 Next Move Operation Date DUPLICATION_STATUS VARCHAR 9 Duplication status
VOLUME_STATUS : ACTIVE / DOWNLOAD / ERROR / EXPIRED / INITIALIZE
EXPIRATION : PERM / VERSIONS / null when EXPIRATION_DATE is used
DUPLICATION_STATUS : BOTH / DUPLICATE / MARKED