UTRAC-User Detail Trace
The UTRAC User Detail Trace display shows all the traced events of the current active thread for a specified user.
It can be accessed only for threads that are being traced (see Starting-a-detail-trace).
SERV ==> UTRAC INPUT 17:25:19 INTVL=> 8 LOG=> N TGT==> DB2D
PARM ==> CIR4X,SEQ=000001,LEVEL=2 ROW 1 OF 85 SCROLL=> CSR
EXPAND: LINESEL(DETAIL)
START: 17:21:38 AUTH: CIR4X PLAN: DSNESPRR CORR: CIR4X CONN: TSO
===============================================================================
EVENT AT ELAPSED CPU DETAIL
-------------- -------- -------- -------- -------------------------------------
SYNC 0.000 4,049 us 1,619 us
LOCK-SUMMARY 0.002 *MAXPG(12) ESCL(0) TS(3)
PREPARE 71 115.047 747 ms 37 ms *RC( 0) C=C1 D/X PS( 22)
BIND-TEXT 115.052 *TYPE=DYNAMIC TEXT=SELECT DBID, OBI+
EXPLAIN 115.791 *PLAN=DSNESPRR COST=0.0
OPEN 131 115.797 2,705 ms 87 ms *RC( 0) C=C1 D/X/W PS( 707)
SORT 115.797 2,703 ms 86 ms REC( 78) RECSZ( 26) WKFILE( 2)
FETCH 125 118.504 1,235 us 664 us *RC( 0) C=C1 W PS( 2)
FETCH 125 118.564 263 us 263 us *RC( 0) C=C1 W
FETCH 125 118.565 291 us 292 us *RC( 0) C=C1 W
FETCH 125 118.566 232 us 233 us *RC( 0) C=C1 W
FETCH 125 118.567 230 us 230 us *RC( 0) C=C1 W
FETCH 125 118.569 257 us 257 us *RC( 0) C=C1 W
FETCH 125 118.570 231 us 231 us *RC( 0) C=C1 W
FETCH 125 118.571 361 us 258 us *RC( 0) C=C1 W
FETCH 125 118.572 332 us 248 us *RC( 0) C=C1 W
Select code
UTRAC
Parameter
The first parameter for this panel is required to identify the thread to be displayed. Any of the following identifiers can be used:
- User ID
- Correlation ID
- Authorization ID
The following parameters are optional:
LEVEL=1 | 2 | 3
The default is 2. You can type levels 1 or 3 in this field to change the display at any time. The entries shown at the three levels depend upon the type of detail trace started (see IFCID-table-ATRAC-data-collection and Event-data).
SEQ=
This parameter is a unique internal sequence number assigned to each trace entry. When UTRAC is first selected, the first active entry in the trace buffer is displayed and identified in the SEQ field. Any valid trace buffer entry can be displayed by typing its trace sequence number in the SEQ field.
Description
This panel shows all the traced events of the current active thread for the specified user. It clears when the thread terminates. The traced events can be displayed at three succeeding levels by using the LEVEL= parameter. These display levels provide the following information:
Level | Description |
|---|---|
LEVEL=1 | Displays only those events related to user requests (SQL statements) plus any exception conditions such as authorization failures, timeouts, or deadlocks. |
LEVEL=2 | Displays level 1 events plus events related to Db2 requests such as CREATE THREAD, EDM requests, or sorts. This display is the default and is the initial display shown when UTRAC is invoked. |
LEVEL=3 | Displays level 1 and level 2 events plus events related to Db2 processing caused by the user and Db2 requests such as scan, I/O, and lock/latch activity. |
Scrolling
Each display can be scrolled up (PF7/19) or down (PF8/20). Data for only the current entry in the trace buffer is scrolled. A new thread in the trace buffer can be displayed by using the left and right PF scroll keys. PF10/22 (left) moves backwards through the thread entries in the buffer. PF11/23 (right) moves forwards through the thread entries. The thread displayed is identified in the SEQ field of the display.
Expand
Pop-up displays of additional statistical information can be selected by positioning the cursor anywhere on the line of an entry that has an asterisk (*) in the DETAIL column and pressing Enter.
An asterisk (*) preceding a field in the DETAIL column means a pop-up display is available for that event.
This section contains the following topic:
Related topic