Viewing DB2 Object Performance Data in the Investigator › Application Performance Monitoring › Active Threads

Active Threads

Application thread activity has perhaps the greatest impact on DB2 performance. Getting accurate and timely information about individual threads is therefore important. DB2 accounting data provides that information.

When you select Active Threads in the Investigator, the following DB2 thread activity is provided so that you can examine and evaluate current activity from a DB2 thread perspective:

• Thread details
• Number of buffer pools and group buffer pools that have been accessed
• Remote location details of the distributed allied thread on the local system
• SQL statement identification information, bind data, and resource use
• Summary information for all locks that are held for a thread
• Packages or DBRM detail information

Control block sampling is used to provide this information.

You can filter on active threads, and then select up to 300 threads to cancel using one of the DB2 Cancel Thread commands. You can also show:

• Group buffer pool and buffer pool details
• The current SQL statement and retrieve the full SQL text of the current statement.

  Note: When viewing SQL text, you can explain it using the DBA Command Manager. The explain displays access path information and CA-supplied recommendations for the statement that can be used to understand the performance of the statement.

• Thread information
• Packages
• Locks held