4. FILES › 5.2 VTS Component Files › 5.2.2 VTS Component IVT Information Area Files › 5.2.2.8 VTS Import/Export File (IVTIEX) › 5.2.2.8.4 IVTIEX Retrieval Examples

5.2.2.8.4 IVTIEX 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 IVTIEX display
    physical and logical volume import and export activity
    for each distributed VTS (UI, secondary, and standalone).

    Summarize the data by date, and generate a single page
    per DATE, with one line for each distributed VTS (UI,
    secondary, and standalone).

    DATA;
    %LET BY=%IEXSEQ(TS=DAYS) ;
    %LET SUMBY=DAY ;
    %LET BREAK=DAY ;
    * ;
    DATA;
    SET &pIVTd..IVTTCA01;
    DATE=DATEPART(ENDTS) ;
    FORMAT DATE DATE8. ;
    %IEXSUM ;
    * ;
    PROC SORT ;
      BY DATE ;
    * ;
    PROC PRINT LABEL ;
    BY DATE ;
    PAGEBY DATE ;
    ID IVTCMPID IVTVLS IVTTYPE ;
    VAR IEXPVI IEXLVI IEXDI IEXDMI IEXPVE IEXLVE IEXDE
        IEXDME ;
    TITLE1 'Overall Daily Import/Export Stats per VTS' ;
    RUN ;