TSUMP-Trace Summary by Plan Name (PLAN)
The Trace Summary by Plan display is a scrollable list of trace entries summarized and sorted by plan name (PLAN column) as shown in the following figure. Both totals and averages of key workload indicators are shown.
SERV ==> TSUMP INPUT 14:24:47 INTVL=> 3 LOG=> N TGT==> DB2D
PARM ==> PBCR02,SORT=PL,GRAPH=NO ROW 1 OF 5 SCROLL=> CSR
EXPAND: LINESEL(LTRAC), HISTORY ENTRIES IN DATASET 1 - 132
19SEP02 PBCRCP - SQL/SCAN/IO 19SEP02 - 17SEP02
THREAD AVG AVG AVG AVG TOTAL TOTAL TOTAL TOTAL
PLAN COUNT ELAPSED CPU #STMTS GETPGS ELAPSED CPU #STMTS GETPGS
-------- ------ -------- -------- ------ ------ -------- -------- ------ ------
DSNESPCS 2 5,516 ms 307 ms 3.0 70.0 11 s 615 ms 6 140
DSNESPRR 3 5,675 ms 446 ms 100.6 109.3 17 s 1,338 ms 302 328
DSNTIA22 12 00:01:49 281 ms 10.6 169.0 00:21:54 3,379 ms 128 2,029
DSNTIB22 11 7,330 ms 122 ms 49.0 34.0 00:01:20 1,351 ms 539 374
DSNUTIL 2 6,740 ms 186 ms 0.0 72.0 13 s 372 ms 0 144
DSN8CC22 22 6,380 ms 18 ms 7.5 10.0 00:02:20 398 ms 165 220
*** END OF SUMMARY ENTRIES ***
Select Code
TSUMP
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. Default is NO. |
,SORT=PL | EC | AE | AC | A# | AG | TE | TC | T# | TG | Sorts the list of summarized trace entries. Initially, the list is sorted alphabetically by plan (default) and ,SORT=PL 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 more 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 [- hhmm ] | Selects the specified time only. |
,D | DAY= nn [- nn ] | Selects the specified day only. |
Summary key
PLAN is the first column of this display. The summary key used for the default sort of summarized trace entries is shown in the first column. The summary key for the TSUMP service is plan name.
Description
This display summarizes the traced threads by plan name. The display is a scrollable list of summary lines for each unique plan name found in the trace entries.
Related topic