5. FILES › 5.3 SCP Information Area Files › 5.3.3 Page/Swap Data Set Activity File (SCPPSD) › 5.3.3.4 Retrieval Examples

5.3.3.4 Retrieval Examples

This section presents a typical SCPSRC retrieval example.


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 average service time for each Page Swap
    data set for each RMF measurement interval;

    DATA;
    SET &PSCPX..SCPPSD01;
     PROC PRINT; VAR SYSID STARTTS ENDTS PSDDSN PSDAVSTM;

2.  Select page/swap data sets having more than 150,000 I/O
    requests and a service time in excess of 0.3 seconds for
    each hour of the day:

    DATA;
    SET &PSCPD..SCPPSD01;
    IF PSDREQ GT 150000;
    IF PSDAVSTM GT 0.3;
    PROC PRINT; VAR SYSID YEAR MONTH DAY HOUR
                PSDDSN PSDREQ PSDAVSTM;

3.  Rank the page/swap data sets by I/O activity and I/O
    service time for the last eight weeks using only prime
    time (zone 1) hours:

    DATA FILE1;
    SET &PSCPW..SCPPSD01 &PSCPW..SCPPSD02
        &PSCPW..SCPPSD03 &PSCPW..SCPPSD04;
    IF ZONE='1';
    %LET BY = SYSID PSDDSN;
    %LET BREAK = PSDDSN;

    PROC SORT DATA=FILE1; BY &BY;

    DATA FILE1;
    SET FILE1;
    %PSDSUM;

    PROC SORT DATA=FILE1; BY DESCENDING PSDREQ;
    PROC PRINT; VAR SYSID PSDDSN PSDREQ PSDAVSTM;
    TITLE 'RANKING OF HIGHEST I/O DATA SETS';

    PROC SORT DATA=FILE1; BY DESCENDING PSDAVSTM;
    PROC PRINT; VAR SYSID PSDDSN PSDREQ PSDAVSTM;
     TITLE 'RANKING OF DATA SETS WITH HIGHEST SERVICE TIME ';