Thread History Buffer Pool Summary

This panel provides summary information about thread buffer pool activity within a report interval.

 
________________ ZHATBUF  VTM     O2       V540.#P DA41 11/06/13 12:14:53   2 
> Help PF1         Back PF3         Up PF7         Down PF8          Zoom PF11 
>                                                                              
>                    Enter a selection letter on the top line.                 
>                                                                              
> A-Summary    *-Buffer Pool    C-DB2 Time    D-Lock/Scan/Sort    E-Alt Summary
> O-OPTIONS                                                                    
===============================================================================
>                      Thread History Buffer Pool Summary                      
 HATH                                                                          
+ Report Interval:   15 mins                     Start: 11/06 10:00:00.000000  
+ Report Filtered:       NO                        End: 11/06 10:14:59.999999  
 buf                                                                           
+                                                                              
+                                           Read   GetP/                Immed  
+ End Time       Plan     Authid   GetPage  I/O    RIO    Pfetch Update Write  
+ ------------   -------- -------- -------  -----  -----  ------ ------ ------ 
+ 10:14:46.339 D DISTSERV MIS           38      0      0       0     18      0 
+ 10:13:44.882 D DISTSERV MIS           37      0      0       0     17      0 
+ 10:12:45.707 D DISTSERV MIS           38      0      0       0     18      0 
+ 10:11:46.491 D DISTSERV MIS           33      0      0       0     13      0 
+ 10:11:32.884 D DISTSERV MIS          202      0      0       0      6      0 
===============================================================================

Navigation

For additional information about
  • a particular thread, move the cursor to the thread information line and press F11 (Zoom).
  • related topics, choose on of the options at the top of the panel.
  • other topics, use the PF keys.

Fields

Report Interval
The time of the thread summary report displayed.
Start
The start date and time of the interval currently displayed.
Report Filtered
This field shows YES if thread filter values were used to create this display. Otherwise, NO is displayed.
End
The end time of the interval currently displayed.
End Time
The end time of the Db2 thread execution.
If this thread involves parallel processing or if it invokes autonomous procedures, one of the following identifiers is displayed after the elapsed time to provide more information about this thread:
*
This thread is a parallel task initiated on behalf of another (originating) thread to process a query request in parallel.
A
This thread is an autonomous procedure rollup record.
D
This thread is a RRSAF/DDF rollup record due to ZPARM ACCUMACC >= 2.
O
This thread is the originating thread that invokes autonomous procedures.
P
This thread is the parent or the originating thread of the parallel tasks that are created to process a query request in parallel. Activity that is performed for this (originating) thread is reflected under the parallel tasks.
R
This thread is a parallel task rollup record due to ZPARM PTASKROL = YES.
Plan
The Db2 plan name.
Authid
The Db2 authorization identifier of the threads.
Getpage
The number of Getpage requests issued.
Read I/O
The number of synchronous Read I/Os performed.
GetP/RIO
The ratio of Getpage requests to synchronous Read I/Os.
Pfetch
The number of Prefetch requests issued.
Update
The number of buffer pool page updates performed.
Immed Write
The number of immediate (synchronous) writes performed.