Skip to Content

Default language.

Analyzing workload history with MainView Explorer charts

The previous sections described how to use the thread history views and thread query dialog to analyze a Db2 workload, detect problems, and investigate problem threads.

Those views provide access to extensive performance data over time, which can be summarized, sorted, and filtered. That large volume of data is useful for analyzing a specific problem, such as:

Related topic

Analyzing-recent-workload-history

  • An end user complaint about performance at a particular time in the past
  • A specific application that was recently changed
  • Threads with high CPU usage

However, that volume of data can make more general analysis very time consuming. The  charts can greatly simplify general analysis tasks, such as gaining a historical perspective of the total workload; detecting problems that you were not aware of; and correlating different measurements and indicators over time. By using the charts, even less experienced users can easily spot anomalies in normal workload patterns and quickly drill down to additional information for that time period.

The charts that are described in the following sections focus on recent historical workload analysis.

For more detailed information about , see Using-MainView-Explorer-and-the-Db2-Health-Navigator, the online Help, or .

This section contains the following topics:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Ops Monitor for Db2 13.1