CA MICS Analyzer Option for DB2 (DB2) Queries › DB2BPH – DB2 Daily Buffer Pool Hit Percent › Modifications

Modifications

The following modifications can be made to the DB2BPH query:

• You can add filter statements to select only a single SYSID or DB2 Region (DB2ID).
• If you do not have the DAYS timespan DBPDBU file active, you can run the query against the DETAIL timespan, Cycles 01 and 02.

Note: This query charts a nonessential data element: DBUDPF (No. Times Dynamic Prefetch Req). If this data element is not active in your DBPDBU file, the query will not fail, but the computed value for buffer hit ratio may be understated. You can ask your CA MICS administrator to check and see if this data element is active. If not, it can be activated by changing the element definition in sharedprefix.MICS.GENLIB(DB2GENIN) from NAMX to NAME and then running the sharedprefix.MICS.CNTL(DB2CGEN) job. After this element is activated, refresh the Q&R Meta Database.