Application Trace Program Summary (with activity counts)

This panel shows information about the traced application thread unit of work at the program level (with activity counts).

OMEGAMON® XE for DB2 PE shows a single line summary of each program that executed at least one SQL call during the trace.


________________ ZATVS    VTM     O2       V540.#P SE12 11/05/13 16:45:31   3  
> Help PF1         Back PF3         Up PF7         Down PF8         Zoom PF11   
>                                                                               
>         APPLICATION TRACE:  Enter a selection letter on the top line.         
>         Current Trace Status: INACTIVE                                        
> *-PROGRAM    B-SQL INDEX    C-SQL DETAIL    D-LOCK DETAIL    E-EVENT DETAIL   
=============================================================================== 
>                      APPLICATION TRACE PROGRAM SUMMARY                        
 ATVS                                                                           
+ Planname=DSNESPCS   Connid=TSO        Corrid=MIS            Authid=MIS        
+                                                                               
+ Progname  InDB2 Time    InDB2 CPU  SQL     Sorts   Locks   Pages   Rows       
+ --------  ------------  ---------  ------  ------  ------  ------  -------    
+ DSNESM68  00:00.00414      .00166       4       0       8      14        4    
===============================================================================

Navigation

For additional information about

a particular program, move the cursor to the program line and press F11 (Zoom). For more information, see the description of panel Application Trace Program Detail.
related topics, select one of the options on the top of the panel.
other topics, use the PF keys.

Fields

Planname: The Db2 plan name of the application.
Connid: The Db2 connection identifier of the application.
Corrid: The Db2 correlation identifier of the application.
Authid: The Db2 authorization identifier of the application.

Progname: The application program name invoked by application.
InDB2 Time: The elapsed time incurred while executing in Db2.
InDB2 CPU: The CPU time incurred while executing in Db2. The value is expressed in 1000ths of seconds. For parallel task activity, this value represents the sum of the parent and child tasks.

SQL: The total number of SQL requests issued by the program.
Sorts: The total number of sorts because of SQL activity issued by the program.
Locks: The total number of locks that were acquired by SQL statements issued by the program. For parallel task activity, this value represents the sum of the parent and child tasks.
Pages: The total number of pages that were referenced (scanned) by the program. For parallel task activity, this value represents the sum of the parent and child tasks.
Rows: The total number of rows that were examined (scanned) by the program. For parallel task activity, this value represents the sum of the parent and child tasks.