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

Query Defaults

• DBPDBU DAYS timespan file: Cycle 01
• Derivations:

  DATE

  DATEPART(ENDTS)
  

  BPHIT

  TEMPDPF=DBUDPF ;
  TEMP=DBUGPGR-SUM(DBUPRFH, DBULPF, TEMPDPF, DBUSRIO);
  IF DBUGPGR GT 0 AND TEMP GT 0 THEN DO ;
      BPHIT = (TEMP / DBUGPGR) * 100;
  END ;