5. FILES › 5.15 DB2 Plan Buffer Pool Activity (DBPDBP)File › 5.15.3 Usage Considerations

5.15.3 Usage Considerations

This section identifies any special considerations or
techniques related to using the DBPDBP file.  Additionally,
several retrieval examples are provided to facilitate the use
of this file.

In the examples, we use a SAS macro to specify the DD name
part of the CA MICS file name.  These macros are a standard
part of CA MICS and are available for all files.  The macro
name has the form  _iiit, where "iii" is the information area
name and "t" is the timespan.  In addition, many of the
examples use the  _fffSUM macro, where "fff" is the file
identifier to summarize the data as indicated by the _BY and
_BREAK macro definitions.

Special Considerations/Techniques

 1.  Care must be exercised in using the special date and
     time data elements contained in each CA MICS file.  As
     the file's granularity increases in higher timespans,
     certain fields loose significance and should not be
     referenced.

     o HOUR should not be used in MONTHS and YEARS.
     o DAY and DAYNAME should not be used in WEEKS, MONTHS,
       or YEARS.
     o WEEK should not be used in MONTHS or YEARS.
     o MONTH should not be used in YEARS.

 2.  The data elements STARTTS and ENDTS have different
     meanings when used in the DETAIL timespan versus their
     meaning in the DAYS, WEEKS, MONTHS, and YEARS timespans.
     The ENDTS and STARTTS, when appearing in the DAYS,
     WEEKS, MONTHS, and YEARS timespans, indicate the span of
     time over which the data has been summarized with
     STARTTS indicating the lowest date and time and ENDTS
     indicating the greatest date and time for the summarized
     data.

Retrieval Examples

 1.  Buffer Pool Activity by DB2 PLAN.

     DATA TEST1;
     SET _DB2D.DBPDBP01
         ;
     YESTRDY=DATE()-1;
     IF DATEPART(ENDTS)=YESTRDY;
     MACRO _BY DB2PLAN DB2AUTH %
     MACRO _BREAK DB2AUTH %
     PROC SUMMARY DATA=TEST1 NWAY;
       CLASS SYSID DB2ID DB2PLAN DB2PID;
       VAR DBPCIMW DBPGPGR DBPLPF DBPPRFH DBPSRIO DBPUUOW;
       OUTPUT OUT=STATS SUM=;
     PROC SORT DATA=STATS; BY SYSID DB2ID;
     PROC PRINT DATA=STATS UNIFORM;
       BY SYSID DB2ID;
       VAR DB2PLAN DB2PID DBPCIMW DBPGPGR DBPLPF DBPPRFH
           DBPSRIO DBPUUOW;
     TITLE YESTERDAYS BUFFER POOL USAGE BY PLAN;