5.2.8.4 Retrieval Examples


This section presents typical HARIPU 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.  Print yesterday's CPU busy percentage for each RMF
    measurement interval:

    DATA;
    SET &PHARX..HARIPU01;
    PROC PRINT; VAR SYSID STARTTS ENDTS IPUADDR IPUPCBS;

2.  Print yesterday's average and maximum hourly CPU busy
    percentage for each hour in zone 1:

    DATA;
    SET &PHARD..HARIPU01;
    IF ZONE='1';
    PROC PRINT; VAR SYSID YEAR MONTH DAY HOUR
                IPUADDR IPUPCBS IPUMPBS;

3.  Display the average IPU busy percentage by SYSID for
    prime time (zone 1) over the last six months:

    DATA;
    SET &PHARM..HARIPU01 &PHARM..HARIPU02
        &PHARM..HARIPU03 &PHARM..HARIPU04
        &PHARM..HARIPU05 &PHARM..HARIPU06;
    IF ZONE='1';
    PROC PRINT; VAR SYSID YEAR MONTH IPUADDR IPUPCBS;