4. FILES › 5.2 VTS Component Files › 5.2.2 VTS Component IVT Information Area Files › 5.2.2.5 Physical Tape Usage File (IVTPTU) › 5.2.2.5.4 IVTPTU Retrieval Examples

5.2.2.5.4 IVTPTU 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 IVTPTU file, show the
    quantity of physical mounts (total and by type), and the
    total, MIN, MAX, and AVG mount times for each hour of the
    day.

    Generate a single page for each distributed VTS (UI,
    secondary, and standalone).

    DATA;
    SET &pIVTd..IVTPTU01;
    DATE=DATEPART(ENDTS) ;
    FORMAT DATE DATE8. ;
    * ;
    PROC PRINT LABEL ;
    PAGEBY IVTVLS ;
      BY IVTCMPID IVTTYPE IVTVLS DATE ;
    ID HOUR ;
    VAR PTUTPM PTUPSTG PTUPMIG PTUPREC PTUPSDE PTUPMTM
    PTUMXPMT PTUMNPMT PTUAVPMT ;
    TITLE1 'Daily Physical Mounts and Times by HOUR' ;
    RUN ;