5. FILES › 5.2 HAR Information Area Files › 5.2.3 Device Type Activity File (HARDTA) › 5.2.3.4 Retrieval Examples

5.2.3.4 Retrieval Examples

This section presents typical HARDVA 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 over the last six
    weeks, for prime time (zone 1) hours, by device type, for
    each hour of the week:

    DATA FILE1;
    SET &PHARW..HARDTA01 &PHARW..HARDTA02
        &PHARW..HARDTA03 &PHARW..HARDTA04
        &PHARW..HARDTA05 &PHARW..HARDTA06;
    IF ZONE='1';
    PROC PRINT; VAR SYSID DEVCLASS DEVTYPE YEAR WEEK
                HOUR DTAAVSTM;

2.  Quantify the growth in I/O activity for 3390 devices over
    the last six months for prime time (zone 1):

   DATA FILE1;
     SET &PHARM..HARDTA01 &PHARM..HARDTA02
        &PHARM..HARDTA03 &PHARM..HARDTA04
        &PHARM..HARDTA05 &PHARM..HARDTA06;
    IF ZONE='1';
    PROC PRINT; VAR SYSID DEVCLASS DEVTYPE YEAR MONTH
               ZONE DTASSC;