5. FILES › 5.2 HAR Information Area Files › 5.2.9 The PR/SM Logical Processor Activity File (HARVPA) › 5.2.9.4 Retrieval Examples

5.2.9.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.  Print yesterday's logical processor utilization for LPAR
    ID 3 for each RMF measurement interval:

    DATA;
    SET &PHARX..HARVPA01; IF SYSID='PROD' AND PRSMLPID=3;
    PROC PRINT; VAR STARTTS VPAADDR VPAPCVPU;

2.  Print yesterday's hourly logical processor effective
    dispatch percentage for LPAR name MVSTEST for each hour
    in zone 1:

    DATA;
    SET &PHARD..HARVPA01;
    IF ZONE='1' AND SYSID='PROD' AND PRSMLPNM=:'MVSTEST';
    PROC PRINT; VAR YEAR MONTH DAY HOUR VPAADDR VPAPCEDT;

3.  Display the average individual logical processor
    utilization for all active partitions by partition name
    for prime time (zone 1) over the last six months:

    DATA;
     SET &PHARM..HARVPA01 &PHARM..HARVPA02 &PHARM..HARVPA03
       &PHARM..HARVPA04 &PHARM..HARVPA05 &PHARM..HARVPA06;
    IF ZONE='1' AND SYSID='PROD';
    PROC SORT; BY PRSMLPNM YEAR MONTH VPAADDR;
    PROC PRINT; BY PRSMLPNM;
    VAR YEAR MONTH VPAADDR VPAPCVPU;