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.

Select a thread and use DB2 cancel thread commands to cancel it. You can also show:

• Group buffer pool and buffer pool details
• The current SQL statement
• Thread information
• Packages
• Locks held