Thread Information

This panel provides information about threads, DBATs, and various engines.


________________ ZJ225B   VTM     O2       V550.#P SE12 11/05/13 16:24:03   2 
>       Help PF1         Back PF3             Up PF7            Down PF8       
> R.M.B                                                                        
>                                                                              
> A-Address Space Summary *-Thread Information C-Shared and Common Storage     
> D-Stmt Cache and xProc  E-Pool Detail        F-IRLM Storage                  
===============================================================================
>                   Thread Information                                         
 J22B                                                                          
+      Active Threads                                                       8  
+      Active and Disconnected DBATs                                        0  
+      Prefetch Engines                                                    13  
+      Deferred Write Engines                                               1  
+      Castout Engines                                                      1  
+      GBP Write Engines                                                    9  
+      P-Lock/Notify Exit Engines                                           2  
+      Active Parallel Child Threads                                        0  
===============================================================================

Navigation

You can scroll through the information using F7 and F8 (if the information requires more than one panel).

For additional options
  • select one of the options from the panel. The same snapshot of DB2 performance data is used as long as Enter is not pressed.
  • use the PF keys.

Fields

Active Threads
Shows the number of active threads (QW0225AT).
Active and Disconnected DBATs
Shows the number of active and disconnected DBATs (QW0225DB).
Prefetch Engines
Shows the number of prefetch engines (QW0225PF).
Deferred Write Engines
Shows the number of deferred write engines (QW0225DW).
Castout Engines
Shows the number of castout engines (QW0225CE).
GBP Write Engines
Shows the number of GBP write engines (QW0225GW).
P-Lock/Notify Exit Engines
Shows the number of P-lock/notify exit engines (QW0225PL).
Active Parallel Child Threads
Shows the number of active parallel child threads (QW0225PT).