For when a first initial is all you can remember
Up to now, we have been looking mostly at db2top as a tool for observing the behavior of your system in real-time, but background mode and recording and playback has shown us that db2top can produce and examine historical data as well. The db2top tool can also be used to perform an analysis on such historical data and present a performance report. This ‘analysis’ feature is the topic of today’s post.
The db2top Analysis feature is invoked only from the command line. I touched upon it once before as one of the sub-options in my post on the -b command line option. It turns out that the analysis sub-option has many sub-options of its own.
You invoke the analysis option by specifying a -A sub-option with the -b (background) command line option. However, analysis can only be performed for a subset of the various background options. This subset is listed in the table below:
|Argument to -b||Performance report name|
A ‘u’ for Utilities and an ‘F’ for Federated also do not result in an error message when used with the -A sub-option, but do not result in any reports.
There is also a sort order for each such report. This sort order is dependent upon the sort setting for the particular screen in db2top as you have it configured in your .db2toprc file. The easiest way to change the sort order is to:
The following video demonstrates the above steps using the Sessions Performance Report:
For columns that can have both a cumulative value and a delta value, the sort order is also influenced by whether the -k option has been specified. When you specify -k, db2top reports the cumulative value. Otherwise, the delta value of such columns is reported. Since these reports sum the values over the time period for which they are measured, the cumulative value is less appropriate and also leads to empty output in the “Performance report, breakdown by 300 seconds” and “Performance report, breakdown by 0.5 hour” reports.
The -m sub-option determines how many minutes of measurement go into the analysis report and the -s sub-option determines how many samples of measurement go into the analysis report.
Combining all these options together, we get the following output from a database named sample when we set Delta_RowsRead/s as the sort column for the Session screen in the .db2toprc file and then perform an 11-minute analysis with this command: db2top -d sample -b l -A -m 11