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 or trace 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 specified request types, such as Getpage requests.