Application Trace Event Detail

This panel shows detailed information about the flow of an application. The information is shown as a series of DB2 events. Each line describes a single event or action. You can control the order by using keywords.

 
________________ ZATD3    VTM     O2       V540.#P SE12 11/05/13 17:48:01   3 
> Help PF1              Back PF3                Up PF7                 Down PF8
>                                                                              
>         APPLICATION TRACE:  Enter a selection letter on the top line.        
>         Current Trace Status: INACTIVE                                       
> A-PROGRAM    B-SQL INDEX    C-SQL DETAIL    D-LOCK DETAIL    *-EVENT DETAIL  
===============================================================================
>                        APPLICATION TRACE EVENT DETAIL                        
 ATD3                                                                          
+ Planname=DSNESPCS   Connid=TSO        Corrid=MIS            Authid=MIS       
+                                                                              
:  Control= NEXT     (FIRST/LAST/NEXT/PREV/nnnn/-nnnn/Snnnn/TOP/BOTTOM/UP/DOWN)
+ Current=000001  Total Number of SQL Calls=000004                             
+                                                                              
+ Event Time   TN Event Type            Event Resource Information             
+ ------------ -- --------------------- ---------------------------------------
+ 16:38:49.959    START PREPARE         PGM=DSNESM68 STMT=00189                
+ 16:38:49.960    START INDEX SCAN      DB=DSNDB06   PS=DSNQYX01               
+ 16:38:49.960    END OF INDEX SCAN     DB=DSNDB06   PS=DSNQYX01               
+                                       ROWS=0000000 PAGES=0000002             
+ 16:38:49.960    START INDEX SCAN      DB=DSNDB06   PS=DSNDTX01               
+ 16:38:49.960    LOCK ACQUIRE          DB=DSNDB06   PS=SYSTSTAB PALK IS  D=CMT
+ 16:38:49.960    LOCK ACQUIRE          DB=DSNDB06   PS=SYSTSTAB ROW  S   D=MNL
+                                       PAGE=000000  RECORD=24                 
+ 16:38:49.962    START INDEX SCAN      DB=DSNDB06   PS=DSNDSX01               
+ 16:38:49.962    LOCK ACQUIRE          DB=DSNDB06   PS=SYSTSTSP PALK IS  D=CMT
+ 16:38:49.962    LOCK ACQUIRE          DB=DSNDB06   PS=SYSTSTSP ROW  S   D=MNL
+                                       PAGE=000000  RECORD=02                 
+ 16:38:49.962    START INDEX SCAN      DB=DSNDB06   PS=DSNDXX07               
+ 16:38:49.962    END OF INDEX SCAN     DB=DSNDB06   PS=DSNDTX01               
+                                       ROWS=0000001 PAGES=0000002             
+ 16:38:49.962    END OF INDEX SCAN     DB=DSNDB06   PS=DSNDXX07               
+                                       ROWS=0000000 PAGES=0000002             
+ 16:38:49.962    END OF INDEX SCAN     DB=DSNDB06   PS=DSNDSX01               
+                                       ROWS=0000001 PAGES=0000002             
+ 16:38:49.962    START INDEX SCAN      DB=DSNDB06   PS=DSNDCX05               
+ 16:38:49.962    LOCK ACQUIRE          DB=DSNDB06   PS=SYSTSCOL PALK IS  D=CMT
+ 16:38:49.962    LOCK ACQUIRE          DB=DSNDB06   PS=SYSTSCOL ROW  S   D=MNL
+                                       PAGE=000000  RECORD=0C                 
+ 16:38:49.962    END OF INDEX SCAN     DB=DSNDB06   PS=DSNDCX05               
+                                       ROWS=0000001 PAGES=0000002             
+ 16:38:49.962    START INDEX SCAN      DB=DSNDB06   PS=DSNATX02               
+ 16:38:49.962    END OF INDEX SCAN     DB=DSNDB06   PS=DSNATX02               
+                                       ROWS=0000000 PAGES=0000002             
+ 16:38:49.962    START INDEX SCAN      DB=DSNDB06   PS=DSNATX02               
+ 16:38:49.962    LOCK ACQUIRE          DB=DSNDB06   PS=SYSTSTAU PALK IS  D=CMT
+ 16:38:49.962    LOCK ACQUIRE          DB=DSNDB06   PS=SYSTSTAU ROW  S   D=MNL
+                                       PAGE=000000  RECORD=02                 
+ 16:38:49.962    END OF INDEX SCAN     DB=DSNDB06   PS=DSNATX02               
+                                       ROWS=0000001 PAGES=0000002             
+ 16:38:49.963    LOCK RELEASE (GROUP)  DURATION=MANUAL                        
+ 16:38:49.963    END PREPARE           ROWS=0000007 PAGES=0000017             
===============================================================================

The data is refreshed each time you press Enter, which shows details for another SQL call.

Navigation

For additional information about

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 active thread.

Connid

The Db2 connection identifier of the active thread.

Corrid

The Db2 correlation identifier of the active thread.

Authid

The Db2 authorization identifier of the active thread.

Control

The next SQL statement that OMEGAMON® XE for DB2 PE displays. This panel initially displays the first SQL statement collected for the thread. Use these keywords to control the display:

FIRST: First SQL statement encountered for the thread.
LAST: Last SQL statement encountered for the thread.
NEXT: Next SQL statement encountered for the thread.
PREV: Previous SQL statement encountered for the thread.
+nnnnn: The nnnnn (1-99999) entry after the currently displayed SQL statement.
-nnnnn: The nnnnn (1-99999) entry before the currently displayed SQL statement.
Snnnnn: Statement number nnnnn.
TOP: Display the first LROWS (number of logical rows) records for the current SQL statement.
BOTTOM: Display the last LROWS records for the current SQL statement.
UP: Scroll up about LROWS records from the current display for the current SQL statement.
DOWN: Scroll down about LROWS records from the current display for the current SQL statement.

Current

The relative number of the SQL statement currently being displayed. This is relative to the total number of calls located for the Db2 unit of work.

Total Number of SQL Calls

The total number of SQL calls located for the DB2 unit of work.

Event Time

The time the event described started.

TN

For parallel processing, this field contains the task number of the child task to which this event applies. For a parent task, or where there is no parallel task activity, this field is blank. The task numbers are assigned arbitrarily at display time to help you distinguish the activity of particular child tasks. Task numbers are not provided by Db2. Events relating to each child task are grouped together following those of the parent task.

Event Type

The Db2 event description. The events displayed are as follows:

Create Thread
End Abort Request
End Alter Database
End Alter Function
End Alter Index
End Alter JAR
End Alter Mask
End Alter Permission
End Alter Procedure
End Alter Sequence
End Alter Stogroup
End Alter Table
End Alter Tablespace
End Alter Trust Ctx
End Close Cursor
End Comment ON
End Commit
End Commit PhaseI
End Commit PhaseII
End Create Alias
End Create AUX Table
End Create Database
End Create Function
End Create Global Tb
End Create Index
End Create JAR
End Create Mask
End Create Permission
End Create Role
End Create Sequence
End Create Stogroup
End Create Synonyn
End Create Table
End Create Tablespace
End Create Trigger
End Create Trust Ctx
End Create Type
End Create Variable
End Create View
End Dcl Glob Temp Tb
End Delete
End Drop Alias
End Drop Database
End Drop Function
End Drop Index
End Drop JAR
End Drop Mask
End Drop Package
End Drop Permission
End Drop Procedure
End Drop Role
End Drop Sequence
End Drop Stogroup
End Drop Synonym
End Drop Table
End Drop Tablespace
End Drop Trigger
End Drop Trust Ctx
End Drop Type
End Drop Variable
End Drop View
End Fetch
End Free Locator
End Grant
End Hold Locator
End Insert
End Label ON
End Lock Table
End of Index Scan
End of Insert Scan
End of Scan
End Open Cursor
End Prepare
End Rename Index
End Rename Table
End Revoke
End Select
End Sequential Scan
End Signon
End Sort
End Stored Procedures
End Terminate Create Thread
End Update
Input Hostvar
Lock Acquire
Lock Change
Lock Release (Group)
Lock Release (Single)
Parallel Degree
Parallel Group End
Start Abort Request
Start Alter Database
Start Alter Function
Start Alter Index
Start Alter JAR
Start Alter Mask
Start Alter Permission
Start Alter Procedure
Start Alter Sequence
Start Alter Stogroup
Start Alter Table
Start Alter Tablespace
Start Alter Trust Ctx
Start Close Cursor
Start Comment ON
Start Commit
Start Commit PhaseI
Start Commit PhaseII
Start Create Alias
Start Create AUX Table
Start Create Database
Start Create Function
Start Create Global Tb
Start Create Index
Start Create JAR
Start Create Mask
Start Create Permission
Start Create Role
Start Create Sequence
Start Create Stogroup
Start Create Synonyn
Start Create Table
Start Create Tablespace
Start Create Thread
Start Create Trigger
Start Create Trust Ctx
Start Create Type
Start Create Variable
Start Create View
Start Dcl Glob Temp Tb
Start Delete
Start Drop Alias
Start Drop Database
Start Drop Function
Start Drop Index
Start Drop JAR
Start Drop Mask
Start Drop Package
Start Drop Permission
Start Drop Procedure
Start Drop Role
Start Drop Sequence
Start Drop Stogroup
Start Drop Synonym
Start Drop Table
Start Drop Tablespace
Start Drop Trigger
Start Drop Trust Ctx
Start Drop Type
Start Drop Variable
Start Drop View
Start Fetch
Start Free Locator
Start Grant
Start Hold Locator
Start Index Scan
Start Insert
Start Insert Scan
Start Label ON
Start Lock Table
Start of Sort
Start Open Cursor
Start Prepare
Start Rename Index
Start Rename Table
Start Revoke
Start Select
Start Sequential Scan
Start Signon
Start Stored Procedures
Start Update
Terminate Thread

Event resource information: Additional information related to the event listed. The following table lists and briefly describes all possible event tokens that can occur in this field.

Event Token

Explanation

Actual=nn

Actual degree of parallelism used.

ALBP

Alter buffer pool lock.

BIND=nn

Degree of parallelism at bind time.

BMBA

Buffer manager SCA MBA L-lock.

BPPS

A buffer manager pageset P-lock.

CCAT

CATMAINT convert catalog lock.

CDIR

CATMAINT convert directory block.

CDRN

Cursor stability read drain lock.

CMIG

CATMAINT migration block.

COLL

Collection lock.

D=x

Lock duration. Possible values:

ALC: Lock is held until the thread is terminated or until the plan is deallocated.
CMT: Lock is held until Commit is processed.
CM+: Lock is held until Commit is processed, unless Lock is needed to maintain the position of the cursor that was opened with the Hold attribute.
FRE: Duration to free all locks.
INT: Lock is held as long as Db2 has interest in the resource. The lock is not dependent on thread Commit or deallocation. This duration is used only for P-locks.
MNL: A lock of short duration that Db2 acquires to do things like authorization checking.
MN+: A lock of short duration that Db2 acquires to temporarily change from CS to RR during bind or DDL.
PLN: Lock is held until plan is deallocated.
UND: Undetermined duration.

DB=x

Database name.

DBEX

Database exception LPL/GRECP lock.

DGTT

DGTT URID lock

DPAG

Data page lock.

DSET

Partitioned lock.

DTBS

Database lock.

GRBP

Group buffer pool start/stop lock.

HASH

Hash anchor lock.

IEOF

Index end of file lock.

IPAG

Index page lock.

IS

Intent share lock.

IX

Intent exclusive lock.

MDEL

Mass delete lock.

NAME=Stored-Procedure-Name SQLCODE=SqlCode

The name Stored Procedure and its return code.

PAGES=n

Number of pages scanned.

PCDB

DDF CDB P-lock.

PDBD

DBD P-lock.

PDSO

Pageset or partitioned pageset open lock.

PGM=x

DBRM name.

PPAG

Page P-lock.

PPSC

Page set/Partition castout P-lock.

PPSP

Page set/Partition P-lock.

PRLF

RLF P-lock.

PS=x

For scan activity, the name of the indexspace or tablespace that caused the lock.

For lock activity, the name of the pageset that caused the lock.

PSET

Pageset lock.

PSPI

Pageset piece lock.

RDRN

Repeatable read drain lock.

RECS=n

Number of records sorted.

ROW

Row lock.

ROWS=n

Number of rows processed.

RSIZE=n

Sort record size (in bytes).

Run=nn

Degree of parallelism at runtime.

RSIZE=n

Sort record size (in bytes).

RSTR

SCA access for restart/redo lock.

S

Shared lock.

SDBA

Start/stop lock.

SIX

Share with intent exclusive lock.

SKCT

Skeleton cursor table lock.

SKPT

Skeleton package table lock.

SPRC

System Level PIT Recovery lock

SQLCode |

SQL code from the CALL to the stored procedure.

SREC

Log range lock.

STMT=n

DBRM statement number.

TABL

Table lock.

U

Update.

UNDT

Undetermined lock.

UTSE

Utility serialization lock.

WDRN

Write drain lock.

X

Exclusive lock.