Previous Topic: 5.2.3.4.3 SVTVMR Usage ConsiderationsNext Topic: 5.2.3.5 Virtual Tape Volume Dismount Request File


5.2.3.4.4 SVTVMR Retrieval Examples


In the examples, a SAS macro variable is used to specify the
DDname part of the CA MICS file name. These macro variables
are a standard part of CA MICS and are available for all
files. The macro variable name has the form &diiit, where d
is the database identifier, iii is the information area
name, and t is the timespan.  For the examples, a database
identifier of P is used.  The identifier is installation
dependent, so you should find out what the identifiers are at
your installation.

 1.  Generate a report displaying virtual tape mount
     activity and mount response time by hour.

          %LET BY    = SYSID VTSSID VTSSMCL HOUR;
          %LET BREAK = HOUR;
          PROC SORT DATA=&psvtx..SVTVMR01 OUT=VMR;
            BY &BY;
          RUN;
          DATA VMR2; SET VMR;
              %VMRSUM(SUMBY=&BY, SUMBREAK=&BREAK);
          RUN;
          PROC PRINT DATA=VMR2 LABEL NOOBS;
            BY SYSID VTSSID;
            VAR SYSID VTSSID VTSSMCL HOUR VMRCOUNT
                VMRMNR VMRMRC VMRAVMTM VMRMNMTM VMRMXMTM;
            TITLE 'Virtual Tape Mount Activity';
          RUN;


     Note: Drop management class from the BY and VAR
           statements to get gross mounts by SYSID and
           VTSSID.