5. FILES › 5.2 HAR Information Area Files › 5.2.10 Storage Group Activity File (HARSGA) › 5.2.10.4 Retrieval Examples

5.2.10.4 Retrieval Examples

This section presents typical HARSGA 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 average number of device allocations in
    effect and I/O activity rate per second over the last six
    weeks for prime time (zone 1) hours, by SYSID for each
    storage group, in YEAR WEEK HOUR order:

    DATA;
    SET &PHARW..HARSGA01 &PHARW..HARSGA02
        &PHARW..HARSGA03 &PHARW..HARSGA04
        &PHARW..HARSGA05 &PHARW..HARSGA06;
    IF ZONE='1';
    PROC SORT; BY SYSID YEAR WEEK HOUR STORNAME;
    PROC PRINT;
    BY SYSID; ID STORNAME;
    VAR YEAR WEEK HOUR SGAAVNDA SGAACTRT;

2.  Quantify the growth in I/O activity for storage group
    PRODDB, over the last six months, for prime time (zone
    1):

    DATA;
    SET &PHARM..HARSGA01 &PHARM..HARSGA02
        &PHARM..HARSGA03 &PHARM..HARSGA04
        &PHARM..HARSGA05 &PHARM..HARSGA06;
    IF ZONE='1' AND STORNAME='PRODDB';
    PROC PRINT; VAR SYSID STORNAME YEAR MONTH ZONE SGAACTRT;