4. FILES › 5.2 VTS Component Files › 5.2.3 VTS Component SVT Information Area Files › 5.2.3.7 Virtual Tape Volume Migrate Request File › 5.2.3.7.4 SVTVGR Retrieval Examples

5.2.3.7.4 SVTVGR 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 migration activity
     by hour.

          %LET BY    = SYSID VTSSID VTSSSCL HOUR;
          %LET BREAK = HOUR;
          PROC SORT DATA=&psvtd..SVTVGR01 OUT=VGR;
            BY &BY;
          RUN;
          DATA VGR2; SET VGR;
               VGRMSZ=VGRMSZ/(1024*1024);
              %VGRSUM(SUMBY=&BY, SUMBREAK=&BREAK);
          RUN;
          PROC PRINT DATA=VGR2 LABEL NOOBS;
            BY SYSID VTSSID;
            VAR SYSID VTSSID VTSSSCL HOUR VGRCOUNT
                VGRAVMTM VGRMXMTM VGRMTA VGRMTI VGRMTD
                VGRMTR VGRMTC VGRMTX VGRMSZ;
            FORMAT VGRMSZ COMMA12.2;
            LABEL VGRMSZ='Uncompressed Size of VTV (MB)';
            TITLE 'VTV Migration Activity';
          RUN;

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