5. FILES › 5.2 HAR Information Area Files › 5.2.12 CF Cache Structure Activity File (HARCFH) › 5.2.12.4 Retrieval Examples

5.2.12.4 Retrieval Examples

This section presents typical HARCFH 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.  Merge yesterday's DETAIL timespan CF Request (HARCFR)
    file with the CF Cache Structure (HARCFH) file to provide
    additional information for CF cache structures.  Print
    structure name, cache read hits, cache changed write
    hits, total reads, and total writes.  Note that no sort
    is required as these two files have an identical
    sort/sequence order:

    DATA;
    MERGE &PHARX..HARCFR01(IN=R) &PHARX..HARCFH01(IN=C) ;
      BY SYSID ENDTS CFYSYSNM CFYCFNM CFYSTRNM ;
    IF R AND C ;

    PROC PRINT;
    VAR CFYSTRNM CFHTORH CFHTOWHC CFHTOR CFHTOW ;

2.  Print any instances of directory entry reclaims occurring
    in CF cache structures yesterday:

    DATA;
    SET &PHARD..HARCFH01;
    IF CFHTODER GT 0 ;

    PROC PRINT;
     VAR SYSID CFYSTRNM CFHTODER ;