TSUML-Trace Summary by Location Name (LOCATION)
The Trace Summary by Location display is a scrollable list of trace entries summarized and sorted by the first eight characters in the location name (LOCATION column) as shown in the following figure. Both totals and averages of key workload indicators are shown.
SERV ==> TSUML INPUT 14:25:20 INTVL=> 3 LOG=> N TGT==> DB2D
PARM ==> PBCR02,SORT=LO,GRAPH=NO ROW 1 OF 1 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
LOCATION COUNT ELAPSED CPU #STMTS GETPGS ELAPSED CPU #STMTS GETPGS
-------- ------ -------- -------- ------ ------ -------- -------- ------ ------
NEW_YORK 23 00:01:00 205 ms 29.0 104.4 00:23:15 4,730 ms 667 2,403
DALLAS 22 6,380 ms 18 ms 7.5 10.0 00:02:20 398 ms 165 220
CHICAGO 1 02:56:33 11 s 0.0 0.0 02:56:33 11 s 0 0
LOS_ANGE+ 5 5,611 ms 390 ms 61.6 93.6 28 s 1,953 ms 308 468
SEATTLE 2 6,740 ms 186 ms 0.0 72.0 13 s 372 ms 0 144
*** END OF SUMMARY ENTRIES ***
Select code
TSUML
Parameter
The following parameters can be specified:
Parameter | Description |
|---|---|
trace id | A unique ID identifying 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=LO | EC | AE | AC |A# | AG | TE | TC | T# | TG | Sorts the list of summarized trace entries. Initially, the list is sorted alphabetically by location name (default) and ,SORT=LO 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. |
,T | TIME= hhmm [- hhmm ] | Selects the specified time only. |
,D | DAY= nn [- nn ] | Selects the specified day only. |
,L | LOC= xxxxxxxx | Selects the specified location name only. |
,R | CORRID= xxxxxxxxxxxx | Selects the specified correlation ID only. |
Summary key
LOCATION 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 TSUML service is the first eight characters of location name.
Description
This panel summarizes the traced threads by location name. The display is a scrollable list of summary lines for each unique location name (eight characters only) found in the trace entries.
Related topic