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.

Default language.

Space announcement The Using section of the MainView for DB2 documentation is now available in Japanese. The displayed language is dependent on your browser language. You can switch languages from the Language menu.

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 MainView for DB2 TLDS
  3. Perform detailed analysis of the thread data in the MainView for DB2 Data Collector trace data sets
  4. Perform detailed analysis of summary package data in the MainView 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*