4. FILES › 5.2 VTS Component Files › 5.2.3 VTS Component SVT Information Area Files › 5.2.3.6 Virtual Tape Volume Delete Request File › 5.2.3.6.4 SVTVXR Retrieval Examples

5.2.3.6.4 SVTVXR 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 deletion
     activity, average age of the VTV and the reason for
     deletion.

          %LET BY    = SYSID VTSSID VTSSMCL HOUR;
          %LET BREAK = HOUR;
          PROC SORT DATA=&psvtd..SVTVXR01 OUT=VXR;
            BY &BY;
          RUN;
          DATA VXR2; SET VXR;
              %VXRSUM(SUMBY=&BY, SUMBREAK=&BREAK);
          RUN;
          PROC PRINT DATA=VXR2 LABEL NOOBS;
            BY SYSID VTSSID;
            VAR SYSID VTSSID VTSSMCL HOUR VXRCOUNT
                VXRAVAGE VXRNMM VXRMPR VXRSPR VXRCON
                VXROLD VXRDSC VXRIMP VXRDSU;
            TITLE 'VTV Deletion Activity';

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