QUSRBRM / MEDIA_INFO

By kimot, 28 December, 2022
BRMS - Media Information

source for this view is QUSRBRM / QA1AMM

WRKMEDBRM

                           Display Media Attributes 
                                                    
Volume serial . . . . . . . . . . :   AS0000        
Media type  . . . . . . . . . . . :   M8            
Container Volume  . . . . . . . . :   N             
Image catalog . . . . . . . . . . :   *NONE         

Media class . . . . . . . . . . . :   TTC_DUPMED    
Expiration date . . . . . . . . . :   *PERM         

Current location  . . . . . . . . :   TS4300    
Scheduled move date . . . . . . . :   *NONE         

Move policy . . . . . . . . . . . :   *NONE         
Creation date . . . . . . . . . . :   23/06/18     

System  . . . . . . . . . . . . . :   EXANET.IBMS1        
Text  . . . . . . . . . . . . . . :   IBMS1  Entire system

Volume Identifier . . . . . . . . :   AS0000               

Media uses  . . . . . . . . . . . :   1                    
Read errors . . . . . . . . . . . :   0                    
Write errors  . . . . . . . . . . :   0                    
File group  . . . . . . . . . . . :   ENTIRE      
Group type  . . . . . . . . . . . :   QBRMBKUP    

 

Fields
Field       Type       Length  Text
VOLSERIAL   VARCHAR         6  Volume Serial
VOLUME_ID   VARCHAR        32  Volume Identifier
STATUS      VARCHAR        10  Volume Status
TYPE        NUMERIC        10  Cartridge type
SYSTEM      VARCHAR        17  Owning System 
MEDIACLASS VARCHAR 10 Media Class
DUPESTATUS VARCHAR 9 Duplication Status
CONTAINER VARCHAR 10 Container
CREATED DATE 4 Created 
EXPIRATION VARCHAR 8 Expiration 
EXPIREDATE DATE 4 Expiration Date 
LOCATION VARCHAR 10 Current Location
MOVEPOLICY VARCHAR 10 Move Policy 
MOVE DATE 4 Scheduled Move 
CATALOG VARCHAR 10 Image Catalog 
USED INTEGER 4 Media Times Used
R_ERRORS BIGINT 8 Read Errors 
W_ERRORS BIGINT 8 Write Errors 
FULL VARCHAR 3 Volume Full 
SERIAL VARCHAR 3 Serial Set
PARALLEL VARCHAR 3 Parallel Set 
RESERVED VARCHAR 6 Volume Reserved 
FILE_GROUP VARCHAR 10 File Group 
GROUP_TYPE VARCHAR 10 File Group Type
TEXT VARCHAR 50 Text