5. FILES › 5.2 HAR Information Area Files › 5.2.8 PR/SM Logical Partition Activity File (HARLPC) › 5.2.8.4 Retrieval Examples

5.2.8.4 Retrieval Examples

This section presents typical HARVPA 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 LPAR processor resource consumption
    for each RMF measurement interval:

    DATA;
    SET &PHARX..HARLPC01; IF SYSID='PROD';
    PROC PRINT;
    VAR PRSMLPNM STARTTS ENDTS LPCPCVPU LPCPCSSU LPCPCTSU;

2.  Print yesterday's hourly LPAR processor resource
    consumption each hour in zone 1:

    DATA;
    SET &PHARD..HARLPC01;
    IF ZONE='1' AND SYSID='PROD';
    PROC PRINT;
    VAR PRSMLPNM YEAR MONTH DAY HOUR
      LPCPCVPU LPCPCSSU LPCPCTSU;

3.  Display the average LPAR processor resource consumption
    by LPAR name for prime time (zone 1) over the last six
    months:
     DATA;
    SET &PHARM..HARLPC01 &PHARM..HARLPC02
        &PHARM..HARLPC03 &PHARM..HARLPC04
        &PHARM..HARLPC05 &PHARM..HARLPC06;
    IF ZONE='1' AND SYSID='PROD';
    PROC SORT; BY PRSMLPNM YEAR MONTH;
    PROC PRINT;
    VAR SYSID YEAR MONTH LPCPCVPU LPCPCSSU LPCPCTSU;