5. FILES › 5.3 SCP Information Area Files › 5.3.4 Resource Enqueue Activity File (SCPENQ) › 5.3.4.4 Retrieval Examples

Previous Topic: 5.3.4.3 Usage Considerations

Next Topic: 5.3.5 Trace Activity File (SCPTRC)

5.3.4.4 Retrieval Examples

This section presents a typical SCPIOC 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 occurrences of the SMF buffer enqueues
     for each RMF measurement interval;

    DATA;
    SET &PSCPX..SCPENQ01;
    IF ENQQNM='SYSZSMF1';
    PROC PRINT; VAR SYSID ENDTS ENQRNM ENQQLT ENQEVT;

2.  Select resource enqueue conflicts for which the queue
    exceeded a length of 3 or greater, more than 30% of the
    time, for each hour of the day:

    DATA;
    SET &PSCPD..SCPENQ01;
    IF ENQPCQL2 LT 70;
    PROC PRINT; VAR SYSID YEAR MONTH DAY HOUR
                ENQQNM ENQRNM ENQQL1 ENQQL2
                ENQQL3 ENQQL4;