5. FILES › 5.2 HAR Information Area Files › 5.2.4 Device Activity File (HARDVA) › 5.2.4.4 Retrieval Examples

5.2.4.4 Retrieval Examples

This section presents typical HARTCA 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 I/O service time for DASD devices
    yesterday:

    DATA FILE1;
    SET &PHARX..HARDVA01;
    IF DEVCLASS EQ: "DASD";
    PROC PRINT; VAR SYSID DEVCLASS DEVTYPE DEVADDR
                STARTTS ENDTS DVAAVSTM;
2.  Display the average I/O service time over the last six
    weeks, for prime time (zone 1) hours, by device type, for
    each hour of the week for the DASD devices on the 4B and
    5B banks:

    DATA FILE1;
    SET &PHARW..HARDVA01 &PHARW..HARDVA02
        &PHARW..HARDVA03 &PHARW..HARDVA04
        &PHARW..HARDVA05 &PHARW..HARDVA06;
    IF ZONE EQ "1";
    IF DEVADDR EQ:'"4B"' OR DEVADDR EQ:"5B";
    PROC PRINT; VAR SYSID DEVCLASS DEVTYPE DEVADDR YEAR
                WEEK HOUR DVAAVSTM;

3.  Display the percent of time that the volumes used for IMS
    have been in one of the not-ready states.  The volumes
    are IMS001, IMS002, and IMS980.

    DATA FILE1;
    SET &PHARX..HARDVA01;
    IF VOLSER EQ "IMS001" OR VOLSER EQ "IMS002" OR
       VOLSER EQ "IMS980";
    PROC PRINT; VAR SYSID DEVCLASS DEVTYPE DEVADDR
                VOLSER STARTTS ENDTS DVAPCMTP DVAPCNRD;