Viewing DB2 Object Performance Data in the Investigator › Application Performance Monitoring › Thread History

Thread History

When you select Thread History, a list of thread termination records is displayed showing an overview of activity for completed threads. Use this information to examine a completed thread for potential problems.

You can filter the display by specifying time range criteria or by entering values that select only particular thread history records.

Use the navigational actions to view thread details and access the following historical data for the specific thread chosen:

• Buffer Pool—Displays data about the DB2 buffer pool activity. This information is useful to determine the DB2 buffers used by the thread.
• Group Buffer Pool—Displays data about the DB2 group buffer pool activity. This information is useful to determine what DB2 group buffers the thread used.
• Packages—Displays data about the packages and DBRMs that were executed for a particular DB2 plan to determine the package or DBRM that is causing performance problems. To display data, accounting trace classes 7 and 8 must be started.
• Remote Stats—Displays all distributed locations on which the thread is (or was) executing to determine the level of distributed activity at each of the remote sites. This information is also helpful to determine if there are problems with switching from continuous block fetch to limited block fetch mode.

Example:

While monitoring your application performance, you notice that a program is taking a long time to complete. Locate the thread in Thread History and look at the packages to see which package is being used for the longest time, indicating a potential problem.