5. FILES › 5.2 VTOC/Catalog Activity Information Area Files › 5.2.3 Volume Allocation File (VCAVOA) › 5.2.3.4 VCAVOA Retrieval Examples

5.2.3.4 VCAVOA 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.  List all volumes that exceeded 90% of space used last
    month, showing the maximum amount of space allocated and
    used.

    DATA;
    SET &PVCAM..VCAVOA01;
    IF VOAMPSPU > 90;
    PROC PRINT; VAR VOLSER STORNAME DEVTYPE VOAMPSPU VOAMXSPA
                    VOAMXSPU;
    RUN;

2.  Show the total megabytes of capacity available and
    allocated space in megabytes for each volume with control
    breaks and totals by storage group.

    DATA WORK.SUBSET
    (KEEP=VOLSER   VOANOATK VOAFVIRS VOACAPMB
          VOASPACA VOATKCAP STORNAME
          VOAALLMB);
    SET &PVCAX..VCAVOA01;
    VOAALLMB = (VOASPACA*VOATKCAP)/1000000;
    RUN;
    PROC SORT DATA=WORK.SUBSET;
     BY STORNAME VOLSER;
    RUN;
    PROC PRINT LABEL DATA=WORK.SUBSET;
     BY STORNAME;
     SUM VOANOATK VOAFVIRS VOACAPMB VOAALLMB;
     VAR STORNAME VOLSER VOACAPMB VOAALLMB;
     SUMBY STORNAME;
    RUN;

Note that VOASPACA (carried in tracks) is converted to bytes
by multiplying by VOATKCAP (the capacity of the track in
bytes).  We divide by one million since that is the basis for
the published capacity of volume geometries that is carried
as VOACAPMB.  A temporary derived element for allocated space
in terms of megabytes is created as VOAALLMB.