Active threads
Views for thread analysis are organized into the following groups:
- Thread summary views
- Thread detail views
One thread record is created for each active thread. These records provide the most important indicators of current thread activity.
| For more information, view the Quick Course Displaying Active Threads. |
Using SSI mode with these views shows the threads from multiple DB2s together in one display. This ability is especially important in a sysplex where incoming work can be processed in any of several different systems and it can be difficult to locate a particular user.
You can access the views for thread analysis from the DB2 Threads easy menu (EZDTHD) (see the following figure).
DB2 Threads Easy Menu
Threads Overview Thread Summaries
. Current Threads +----------------------+ . Attach Summary
. All Connected Threads | Place cursor on | . Connect Summary
. Thread List (Customize | menu item and | . Plan Summary
. Threads in Warning | press ENTER | . Users Summary
. Inactive Connects/Thds +----------------------+ . DB2 Summary
. Parallelism Summary
Threads by Connection . CICS/DB2 Connections Workload Overview
. All CICS Threads . Workload Objectives
. CICS Protected Threads . All Stor Proc Thds . Rsp/Cnts 10 Intervals
. All IMS Threads . SPAS Stor Procs . Response 10 Intervals
. All Utility Threads . WLM Stor Procs . Counts 10 Intervals
. DBAT and RRSAF Thds . Wkld Rate/Sec 10 Intvls
. SAP Threads
The following table lists the views available for threads:
View name | Group | Type | Description |
|---|---|---|---|
APPSTOBJ | Detail | Tabular | Object Data Displays object data for the currently executing statement for an active thread, and other metrics that APPTUNE collects (such as GETPAGES and I/O data) You can access this view from the THDACTV view. |
DUSER | Hybrid | Tabular | Thread Detail DUSER Provides complete data for an individual thread The most critical data and key indicators regarding thread status is summarized in the base section of the view. |
THDACTD | Detail | Tabular | All Active Threads Displays information about each active thread This view is similar to the THDACTV view, except for the display format of the CPU Time and Elapsed Time fields. In THDACTD, these fields can show the time for database active threads (DBATs) in increments of less than 1/100 of a second. |
THDACTV | Detail | Tabular | All Active Threads Displays information about each active thread Use the Show/Hide Header toggle to display additional hyperlinks to useful related views, and for a description of the row hyperlinks in the view. Use the C line command to issue the DB2 CANCEL THREAD command. Hyperlink from the Correlation ID column to access extensive thread data in the DUSER view. If the MainView for DB2 - Data Collector component is active, you can hyperlink from the Current Activity column to access Explain information for an active SQL statement in a current thread. |
THDALL | Detail | Tabular | All Connected Threads Displays information about each connected thread |
THDCICPR | Detail | Tabular | CICS Protected Thread Averages Displays information about CICS protected threads Use this view to see average counts and times across the multiple CICS transactions that are executed under a single protected thread. |
THDCICS | Detail | Tabular | All CICS Threads Displays information about all CICS threads by connection Use this view when you want to focus only on the active CICS threads. |
THDCONNZ | Summary | Summary | Thread Summary by Connection Summarizes current thread activity by connection name Use this view to see an overview of current activity by the source of each workload, such as CICS, IMS, batch, or TSO connections. In SSI mode, it shows the total workload in the defined context. This information can be especially valuable in a data sharing sysplex. |
THDCTYPZ | Summary | Summary | Thread Summary by Connection Type Summarizes current thread activity by connection type Use this view to see an overview of current activity by attach type, such as CICS, TSO, IMS-MPP, or IMS-BMP. In SSI mode, it shows the total workload in the defined context. This information can be especially valuable in a data sharing sysplex. |
THDDB2Z | Summary | Summary | Thread Summary by DB2 ID Summarizes current thread activity by the target DB2 subsystem ID Use this view to see an overview of current activity for each DB2 in the defined context. |
THDDBAT | Detail | Tabular | All Data Base Access Threads Displays information about each active or pooled distributed thread (DBAT) |
THDDETL | Detail | Detail | Thread Detail Shows detailed information about the selected user Use this view to view all collected information for a thread. Additional information is available through alternative hyperlinks to the DUSER display. If the MainView for DB2 - Data Collector is active, a hyperlink is available from the SQL Stmts field to access Explain information for active SQL. |
THDIMS | Detail | Tabular | All IMS Threads Displays information about all IMS threads by connection Use this view when you want to focus only on the active IMS threads. |
THDJOBD | Tabular | Tabular | Job Threads Displays information about all threads that are currently executing for a job |
THDJOBZ | Summary | Summary | Thread Summary by Job Name Summarizes current thread activity by job name |
THDLIST | Detail | Tabular | All Active Threads--Long Form Displays information about each active thread Use this view to customize one or more views with exactly the data that you want to see for your workloads. |
THDPLANZ | Summary | Summary | Thread Summary by Plan Name Summarizes current thread activity by plan name Use this view to see an overview of current activity by application. In SSI mode, it shows the total workload in the defined context. This information can be especially valuable in a data sharing sysplex. |
THDPRLLD | Detail | Tabular | Parallel Query Detail Shows each active task of a parallel query Use this view to understand the total scope of a parallel query. In a data sharing group context, it shows all parallel tasks running in multiple DB2 members with sysplex query parallelism. |
THDPRLLZ | Summary | Summary | Summary of Parallel Queries Summarizes all queries that have invoked the parallel processing feature Use this view to see an overview of all parallel queries currently active in the defined context. In a data sharing group, it includes all parallel tasks running with sysplex query parallelism. |
THDPROCZ | Summary | Summary | Thread Summary for Stored Procs Displays information about all threads that are currently executing a stored procedure |
THDRRS | Detail | Tabular | All RRSAF Threads Displays information about the RRSAF threads for each remote location Use this view when you want to focus only on the active RRSAF threads. |
THDSAP | Detail | Tabular | All Active DB2 SAP Threads Displays active threads with the DB2 workstation ID fields formatted as SAP identifiers, such as the application server and process ID Use this view to relate DB2 threads to SAP requests. |
THDSAPD | Detail | Detail | SAP Thread Detail Displays detailed information about the selected active SAP thread Use this view for further analysis of a SAP thread. |
THDSTPR | Detail | Tabular | Stored procedure threads Displays information about all threads executing in a DB2 stored procedure |
THDTSO | Detail | Tabular | All TSO/Batch Threads Displays information about all TSO and batch threads Use this view to focus on active TSO foreground and background threads. |
THDUSERZ | Summary | Summary | Thread Summary by User ID Summarizes current thread activity by user ID Use this view to see an overview of current activity by user ID and DB2. This data is useful mainly for sources of multiple threads like CICS or the DB2 internal threads labeled SYSOPR. |
THDUTIL | Detail | Tabular | Active DB2 Utility Threads Displays information about active utilities, showing phase activity |
THDWARN | Detail | Tabular | Key Indicator/Warnings Provides information about the most important key indicators of failures or degradation Use this view to see if the selected threads have more than one warning indicator set. A hyperlink on the Indicator Msg column shows more information about these warnings. |
THDWARND | Detail | Detail | Key Indicator/Warnings Detail Displays detailed information about key indicator warning messages for the selected user Use this view to analyze threads that have more than one warning. |
TIACNDS | Detail | Tabular | CDC Report TIACNDS If the MainView for DB2 - Data Collector component is active, this view displays the data sets that are currently accessed by a thread. To display TIACNDS, hyperlink on the THDACTV view Getpage Total field. |
Related topic