4. FILES › 5.2 VTS Component Files › 5.2.2 VTS Component IVT Information Area Files › 5.2.2.6 Volume Pool Statistics File (IVTVPS) › 5.2.2.6.4 IVTVPS Retrieval Examples

5.2.2.6.4 IVTVPS 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 plot showing the quantity of physical
    cartridges at each of 20 bracketed percent utilization
    levels for each volume pool with active cartridges.

    Use the data from the last hour of the most recent DAYS
    timespan data. Only include volume pools with active
    cartridges.

    Use an array and a DO loop with 20 iterations to access
    the 20 VPSSDVnn data elements.  An equation is used to
    convert the DO loop variable (I) to grab every 5th
    element in array, which corresponds to the VPSSDVnn data
    element names.

    DATA;
    SET &pIVTd..IVTVPS01;
    DATE=DATEPART(ENDTS) ;
    FORMAT DATE DATE8. ;
    LABEL VOLCOUNT="Cartridge Count" ;
    LABEL AVAL="Percent Cartridge Utilization" ;
    ARRAY BUCKETS {96} VPSSDV00-VPSSDV95 ;
    IF HOUR=23 ;
    IF VPSSDVTO GT 0 ;
    DO I=1 TO 20  ;
     VOLCOUNT=BUCKETS(((I-1)*5)+1); /*1st, 5th, 10th, etc.*/
     AVAL=PUT((I*5-5),2.) ;         /*00, 05, 10, 20, etc.*/
     OUTPUT ;
    END ;
    * ;
    PROC SORT ;
      BY IVTVLS IVTTYPE IVTVPN ;
    * ;
    PROC CHART ;
      BY IVTVLS IVTTYPE IVTVPN ;
    VBAR AVAL / SUMVAR=VOLCOUNT DISCRETE;
    TITLE1 'Physical Cartridge PCT Utilization Distribution';
    RUN;