4. FILES › 5.1 TLM Component Files › 5.1.2 TMC Information Area Files › 5.1.2.2 Tape Volume File (TMCTMV) › 5.1.2.2.4 TMCTMV Retrieval Examples

5.1.2.2.4 TMCTMV 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.  Display the number of scratch, non-scratch, total, and
    percent scratch volumes for each Volume Group (VOLGROUP)
    and DFSMS Management Class Name (STORMGTC) using the most
    recent DAYS timespan observation.

    DATA ;
    SET &PTMCD..TMCTMV01 ;
    DATE=DATEPART(ENDTS) ;
    FORMAT DATE DATE8. ;
    *;
    PROC SORT ;
      BY TAPELIB TLMPROD DATE VOLGROUP STORMGTC;
    *;
    PROC PRINT LABEL ;
      BY TAPELIB TLMPROD DATE ;
      PAGEBY TAPELIB ;
    ID VOLGROUP STORMGTC ;
    VAR TMVVOLT TMVVOLN TMVVOLS TMVPCVSC ;
    TITLE1 'Tape Volume Availability Report' ;