Previous Topic: 5.2.3.8.3 SVTVRR Usage ConsiderationsNext Topic: 5.2.3.9 Virtual Tape Volume Movement File (SVTVMV)


5.2.3.8.4 SVTVRR 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 VTV recall activity
     by hour.

          %LET BY    = SYSID VTSSID VTSSSCL HOUR;
          %LET BREAK = HOUR;
          PROC SORT DATA=&psvtd..SVTVRR01 OUT=VRR;
            BY &BY;
          RUN;
          DATA VRR2; SET VRR;
              %VRRSUM(SUMBY=&BY, SUMBREAK=&BREAK);
          RUN;
          PROC PRINT DATA=VRR2 LABEL NOOBS;
            BY SYSID VTSSID VTSSSCL;
            VAR HOUR VRRCOUNT
                VRRAVRTM VRRMXRTM VRRMNRTM VRRMTA VRRMTN
                VRRMTD VRRMTR VRRMTC VRRMTX VRRBCM;
            TITLE 'VTV Recall Activity';
          RUN;

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