Sorting the display
The trace summary displays show a list of scrollable, summarized trace entries sorted by summary key (first display column) for the selected trace summary (AUTHID for TSUMA, CONN for TSUMC, PLAN for TSUMP, LOCATION for TSUML, CORR for TSUMR, TIME for TSUMT).
Any of the column data in the display can be sorted by typing the first two characters of the column heading with the SORT parameter as:
,SORT=cc
where cc can be any of the following two characters:
Parameter | Description |
|---|---|
AU | CO | PL | LO | CR | IS | Sorts the list alphabetically by authorization ID (AUTHID column in TSUMA service), connection name (CONNECT column in TSUMC service), plan name (PLAN column in TSUMP service), location name (LOCATION column in TSUML service), correlation ID (CORR column in TSUMR service), or by ascending time (INTERVAL START column in TSUMT service) |
EC | Sorts the list in a numerically descending order by entry count (ENTRY COUNT column) |
AE | Sorts the list in a numerically descending order by average elapsed time (AVG ELAPSED column) |
AC | Sorts the list in a numerically descending order by average CPU time (AVG CPU column) |
A# | Sorts the list in a numerically descending order by average number of statements (AVG #STMTS column) |
AG | Sorts the list in a numerically descending order by average number of GETPAGEs (AVG GETPGS column) |
TE | Sorts the list in a numerically descending order by total elapsed time (TOTAL ELAPSED column) |
TC | Sorts the list in a numerically descending order by total CPU time (TOTAL CPU column) |
T# | Sorts the list in a numerically descending order by total number of statements (TOTAL #STMTS column) |
TG | Sorts the list in a numerically descending order by total number of GETPAGEs (TOTAL GETPGS column) |
ISD (Interval Start Descending) | Displays the most current measurements at the top (TSUMT only) |
Related topic