Triggers Thread Summary

This panel provides an overview of the activity of all threads that are currently connected to DB2 and that are running a trigger. Each row of the display relates to an individual trigger thread.


________________ ZTRIGT   VTM     O2       V540.#P DA41 S 11/05/13 13:31:45 2 
> Help PF1      Back PF3       Up PF7      Down PF8     Sort PF10    Zoom PF11 
> T.M                                                                          
>         Thread Activity:  Enter a selection letter on the top line.          
                                                                               
> A-All-Idle    B-TSO      C-CICS      D-IMS     E-Background   F-Dist Allied  
> G-Dist DBAC   H-Util     I-Inact     J-Filter  K-Functions    L-Stored Proc  
> *-Triggers    N-Sysplex  O-Enclaves  P-Worksta Q-All+Idle                    
===============================================================================
>                     Triggers Thread Summary                                  
 THDG                                                                          
+ *                                                                            
+ Trigger  In DB2     In DB2     SQL               In DB2                      
+ Name     Elapsed    CPU        Requests Waits    Wait Time  Planname Jobname 
+ -------- ---------- ---------- -------- -------- ---------- -------- --------
+ TRUPDT   00:00:46.8     10.682  1385253      120 00:00:00.0 DSNACLI  YRT52605
===============================================================================

Navigation

For additional information about

A different Db2 subsystem, data sharing group, or member of a data sharing group, enter the name of a DB2 subsystem, group, or member in the topmost row and press Enter.
related topics, select one of the options at the top of the panel.
other topics, use the PF keys.

Fields

Trigger Name: The name of the job executing the trigger.
In Db2 Elapsed: The total In-DB2 elapsed time in seconds for the triggers.
In Db2 CPU: The total In-DB2 CPU time in seconds for the trigger.
SQL Requests: The number of SQL statements issued in the trigger.
Waits: The total number of times that the thread had to wait for a class 8 event to complete while executing the trigger. This field requires an Accounting trace class 8. If this trace is not active, N/A is displayed.
In Db2 Wait Time: The total time that the thread waited.
Planname or Package: The Db2 plan name (or package name) of the active thread. If you selected option T from the Realtime Main Menu, this panel shows the information by plan. If you selected option U, this panel shows the information by package.
Jobname: The name of the job that is executing the trigger.; For remote Db2 subsystems, the correlation ID is displayed instead of the job name.