This site will undergo a maintenance outage on Saturday, 13 September beginning at 2:30 AM Central/1 PM IST for a platform upgrade. The downtime will be ~three hours.

Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Ops Monitor for Db2 13.1 image-2024-5-19_8-5-1.png .

Analyzing the Db2 workload

The following scenarios teach you how to gain a quick overview of summary thread history data to identify problem areas and drill down to further detail if needed to pinpoint exception threads. You will also learn to use the trace displays and the sorting and selection features to pinpoint problem areas and exception threads.

In this practice session, you will:

  1. Analyze recent workload history through thread interval summary views.
  2. Perform detailed analysis of the thread data in an BMC AMI Ops Monitor for Db2 TLDS.
  3. Perform detailed analysis of the thread data in the BMC AMI OpsM for Db2 Data Collector trace data sets.
  4. Perform detailed analysis of summary package data in the BMC AMI OpsM for Db2 Data Collector trace data sets.
  5. Use MainView Explorer charts for graphical workload history analysis.
  6. Print workload reports for offline review.

Note

This practice session takes approximately one hour to complete.

This section contains the following topics:

 

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