4. FILES › 5.2 VTS Component Files › 5.2.2 VTS Component IVT Information Area Files › 5.2.2.3 VTC Statistics Detail File (IVTVTC) › 5.2.2.3.4 IVTVTC Retrieval Examples

5.2.2.3.4 IVTVTC 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.  Using the most recent DAYS timespan IVTVTC file, show the
    virtual tape mounts (total, fast ready, cache-hit, and
    recall) data transferred (total, read and write), write
    compression ratio and average channel MB/sec rate for
    each VTC controller.

    Summarize the data by VTC Controller (IVTVTCNO) to show
    the totals for each controller over all 24 hours of the
    day.

    %LET BY=%VTCSEQ(TS=DAYS) ;
    %LET SUMBY=IVTVTCNO ;
    %LET BREAK=IVTVTCNO ;
    * ;
    DATA;
    SET &pIVTd..IVTVCL01;
    DATE=DATEPART(ENDTS) ;
    FORMAT DATE DATE8. ;
    %VTCSUM ;
    * ;
    PROC PRINT LABEL ;
      PAGEBY IVTVLS ;
      BY IVTCMPID IVTTYPE IVTVLS DATE ;
    ID IVTVTCNO ;
    VAR VTCTVM VTCVFRM VTCVCHM VTCVRM VTCDTVV VTCDRVV VTCDWVV
        VTCAVCLC VTCPSCH ;
    TITLE1
    'Overall Daily Composite VTC Controller Statistics' ;