Thread Detail Workspace

The Thread Detail workspace provides detailed information about the activity of an individual thread.

This workspace is comprised of the following views:

• Thread ID (table view), which identifies the thread.
• Accounting Time (chart view)
• In-DB2 Times (table view), which shows class 2 CPU time (in DB2).
• Triggers (table view)
• Thread Activity (table view), which provides information about the status of the thread, the CPU, and parallel tasks.
• User-Defined Functions (table view)
• Stored Procedures (table view)
• Savepoints (table view)
• Thread SQL counts 1 (table view), which provides information on the following statements associated with a thread:
  • SQL DCL (Data Control Language) declarations
  • SQL DDL (Data Definition Language) statements
  • SQL DML (Data Manipulation Language) statements
• Thread SQL counts 2 (table view), which provides information on:
  • Stored Procedures
  • User-Defined Functions
  • Triggers
  • Direct Row Access
  • Parallelism
  • RID Pool Access
  • Prepare Statements
• Thread SQL counts 3 (table view), which provides information on:
  • Multi-Row Processing
  • Concentrate Statements

All other tables provide details on the named activities.

You can use the HTML navigation feature to navigate from one workspace to another, while passing context information to the next workspace. The workspaces that belong to the same functional unit are linked using HTML navigation. Tivoli Enterprise Portal workspaces are grouped into the following units: Thread Summary workspaces, Thread Detail workspaces, and Statistics workspaces.

Based on the information that this workspace provides, you can recommend changes, set up situations, and verify that your recommended changes improve system performance.