5. FILES › 5.3 SCP Information Area Files › 5.3.1 Paging Activity File (SCPPAG) › 5.3.1.4 Retrieval Examples

5.3.1.4 Retrieval Examples

This section presents typical SCPPAG 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 system paging rate for each RMF
    measurement interval:

    DATA;
    SET &PSCPX..SCPPAG01;
    PROC PRINT; VAR SYSID STARTTS ENDTS PAGSPG;

2.  Print yesterday's average and maximum hourly system
    paging rate for each hour in zone 1:

    DATA;
    SET &PSCPD..SCPPAG01;
    IF ZONE='1';
    PROC PRINT; VAR SYSID YEAR MONTH DAY HOUR
                PAGPSSPG PAGMSSPG;

3.  Print the percentage of all swaps over the last six weeks
    that fell into each of the eight basic swap reason
    categories during the prime-time (zone 1 hours), by hour:

    DATA;
    SET &PSCPW..SCPPAG01 &PSCPW..SCPPAG02
        &PSCPW..SCPPAG03 &PSCPW..SCPPAG04
        &PSCPW..SCPPAG05 &PSCPW..SCPPAG06;
    IF ZONE='1';
    PROC PRINT; VAR SYSID YEAR WEEK HOUR PAGPCLWS
        PAGPCDWS PAGPCULS PAGPCNRS PAGPCASS PAGPCRSS
        PAGPCEXS PAGPCEES PAGPCTIS PAGPCTOS PAGPCTWS;

4.  Print the number of pages moved to expanded storage
    yesterday, and the percentage of those pages that were
    migrated to auxiliary storage, by hour.

    DATA;
    SET &PSCPD..SCPPAG01;
    PERCENT=100*(PAGPEA/PAGPES);
    PROC PRINT;
    VAR SYSID HOUR PAGPES PAGPEA PERCENT;