The Buffer Pool Statistics Highlights section

This report section shows selected elements from the buffer pool statistics section.

This report section shows selected elements from The Buffer Pool Statistics section that deserve further investigation. Note especially those values that are marked with asterisks; they mark counter values that should typically be zero. The content and length of this report section varies. Several elements are always present, others only if the underlying counter values demand highlighting. If you need a detailed description of these elements, see The Buffer Pool Statistics section. The elements are displayed in equal order in both sections. The following example shows a hypothetical section, with some of the elements that can show up in your actual report.

1     OMEGAMON XE FOR DB2 PE (V5R4M0) - BUFFER POOL ACTIVITY REPORT    PAGE: 1-2
                              ORDER: BPID-QPAGESET
                 SORTBY: BPID,ASYNCPAGE  TOP: 17  LEVEL: SUMMARY
 GROUP:     DSNJ        LOCATION:       PMODSNJ             DB2 VERSION: V11
 MEMBER:    SGJ1        REQUESTED FROM: NOT SPECIFIED       TO: NOT SPECIFIED
 SUBSYSTEM: SGJ1        INTERVAL FROM:  01/24/13 07:21:46   TO: 01/24/13 09:27:13
  
                   =======  Buffer Pool Statistics Highlights  ==========
 BUFFER  POOL ID                  BP0        BP2
 ------------------------- ---------- ----------
 Buffers allocated               1484       2642
 System hit ratio               99.34        n/c
 Application hit ratio          99.34        n/c
 Getpage request                 5921          0
 Synchron.read sequential           4*        16*
 Parallel query request
  Reduced                           5*         8*
 ========================= ========== ==========
⋮