TOP subcommand option
The TOP subcommand option lists all applications or users
that have required most use of specific DB2® resources.
Usage
To identify report entries with a
high value in certain fields, you can produce an Accounting report
or trace with TOP lists. TOP lists are index-like reports at the end
of a report or trace pointing out the most interesting entries in
the report or trace. You generate such lists using the TOP subcommand
option.
Usage notes
- TOP is only used in the Accounting report set.
- Entries with 0 or undetermined values are not shown. Moreover,
if your input data contains only 0 or undetermined values for the
TOP fields requested, a TOP list is not generated.
Keywords
- ONLY
- Filters a report or trace such that only the main resource consumers
are shown, ordered by descending resource value.
Note:
The TOP(ONLY)
subcommand option changes the presentation sequence of Accounting
reports and traces. Report and trace entries are ordered according
to the TOP resource instead of the timestamp or ORDER subcommand options.
The summarization in reports is not affected by the changed sequence
caused by TOP filtering.
- n ONLY
- Filters a report or trace such that only the top n entries
for the default TOP field are shown, where n is
a number.
- TOTAL
- The resource values shown are average values. To get total values,
that is, the main resource consumers calculated by taking into account
how often they consumed resources, you specify the TOP subcommand
option with the TOTAL keyword.
Note:
TOTAL only applies to reports.
If you specify it with a trace, it is ignored.
- *
- Generates Accounting reports and traces showing TOP lists for
all the fields available for use with the TOP subcommand option.
- n request type
- Produces a trace with a TOP list for the defined number n of
the specifiedrequest types, such as Getpage requests.
Examples
For more information and examples
refer to the Reporting User's Guide.