TSUMR-Trace Summary by Correlation ID (CORR-ID)
The Trace Summary by Correlation ID display is a scrollable list of trace entries summarized and sorted by the DB2 correlation ID (CORR column) as shown in the following figure. Both totals and averages of key workload indicators are shown.
SERV ==> TSUMR INPUT 15:15:22 INTVL=> 5 LOG=> N TGT==> DB2HHH
PARM ==> WORKSTTN,SORT=CR,GRAPH=NO ROW 1 OF 3 SCROLL=> CSR
EXPAND: LINESEL(LTRAC) ENTRIES IN DATASET 1 - 74
DB2 APPLICATION TRACE
THREAD AVG AVG AVG AVG TOTAL TOTAL TOTAL TOTAL
CORR COUNT ELAPSED CPU #STMTS GETPGS ELAPSED CPU #STMTS GETPGS
-------- ------ -------- -------- ------ ------ -------- -------- ------ ------
db2bp.ex 72 11 s 742 ms 9.1 14.6 00:13:47 53 s 658 1,049
BOLJEH1 1 01:19:13 9,184 ms 0.0 0.0 01:19:13 9,184 ms 0 0
BOLJEH2 1 00:42:42 00:04:15 29.0 295K 00:42:42 00:04:15 29 295K
*************************** END OF SUMMARY ENTRIES ***************************
Select code
TSUMR
Parameter
The following parameters can be specified:
Parameter | Description |
|---|---|
trace id | A unique ID that identifies the trace. A blank can be an identifier. This parameter is the first positional parameter; a comma delimits the next parameter. If there is no identifier, a comma must precede any other parameter. |
,GRAPH=NO | AVG | TOT | Displays a graphic presentation of the ENTRY COUNT (number of threads) followed by either the averages (AVG) or the totals (TOT). NO requests a numerical display of both average and total values. The default is NO. |
,SORT=CR | EC | AE | AC | A# | AG | TE | TC | T# | TG | Sorts the list of summarized trace entries. Initially, the list is sorted alphabetically by DB2 correlation ID (default) and ,SORT=CR is displayed in the PARM field (the comma is a required positional parameter for SORT). SORT specifies the first two characters of a display column as described in Sorting-the-display. |
Selecting-a-subset-of-trace-entries provides information about the following parameters that applies to all the trace summary services: | |
,A | AUTHID= xxxxxxxx | Selects the specified authorization ID only. |
,C | CONNECT= xxxxxxxx | Selects the specified connection name only. |
,P | PLAN= xxxxxxxx | Selects the specified plan name only. |
,L | LOC= xxxxxxxx | Selects the specified location name only. |
,R | CORRID= xxxxxxxxxxxx | Selects the specified correlation ID only. |
,T | TIME= hhmm [- nn ] | Selects the specified time only. |
,D | DAY= nn [- nn ] | Selects the specified day only. |
Summary key
CORR is the first column of this display. The summary key that is used for the default sort of summarized trace entries is shown in the first column. The summary key for the TSUMR service is the DB2 correlation ID.
Description
This panel summarizes the traced threads by DB2 correlation ID. The display is a scrollable list of summary lines for each unique correlation ID found in the trace entries.
Related topic