Viewing active threads

Use the Db2 Active Threads panel (KDPTHD52) to view thread activity for a specific DB2® subsystem, including key performance data such as CPU rate, in-Db2 time, wait time, Db2 status, getpage, commits, and updates.

Procedure

  1. Select the Db2 tab on the OMEGAMON Products panel to show the All Active Db2 Subsystems workspace.
  2. Type a / in the line command field next to the Db2 subsystem of interest and press Enter.
  3. In the option menu, select option 14 (T Active Threads) and press Enter.
    The Db2 Active Threads panel (KDPTHD52) shows the following tabs:
    Active Threads
    Shows information about Db2 Active Threads.
    CICS®
    Shows a summary of CICS threads (KDPTHCIS).
    Utilities
    Shows an overview of the active utilities, including utilities that have not yet completed their run due to of abnormal termination (KDPUTILS).
    ResMgr
    Shows the Db2 System Resource Manager (KDPSUBSM).
    KPI
    Shows the Db2 Key Performance Indicators (KDPKPI1).
  4. To perform actions for Db2 active threads, on the Active Threads tab, type a / in the line command field next to the plan of interest and press Enter.
    These options are available:
    C Cancel Thread (KDPTCANC)
    Cancel a thread.
    A Thread Detail Accelerator (KDPTHRDC)
    View information about accelerator metrics for an active thread.
    B Thread Detail Buffer Pool
    View information about buffer pools for an active thread.
    D Thread Detail Distributed (KDPTHDD2)
    View information about the VTAM APPC conversations and TCP/IP conversations of a distributed (DDF) thread.
    E Thread Detail Enclave (KDPTHDE2)
    View information about the workload manager (WLM) enclave service periods.
    G Thread Detail Group Buffer Pool
    View information about group buffer pools for an active thread.
    L Thread Detail Locks Owned (KDPTHRDL)
    View information about the locks and the claims that are owned by an individual thread.
    N Thread Detail Long Names (KDPTHRDN)
    View the long names (identification fields) that are associated with a specific thread.
    Q Thread Detail SQL Counts (KDPTSQL1)
    View the SQL counts for the Data Manipulation Language (DML) for a thread.
    S Thread Detail Accounting (KDPTHDA2)
    View the accounting classes 1 and 2 for a selected thread. From the CICS Transaction Details subpanel, zoom in to:
    • CICS Region Summary (KCPRGNS) : zoom into:
      • ! Take Actions on Task (KDPTASAP)
      • D CICS DB2 Connection Summary (KCPD2S or KCPD2P)
      • B CICS Bottlenecks (KDPBOTS)
      • F CICS File/Data Resources (CICS File/Data option menu)
      • R CICS Resources (CICS Resources option menu)
      • S CICS Region Overview (KCPRGNO)
      • T CICS Task Summary (KDPTASS)
    • Transaction ID: navigate to CICS workspace Transaction Details (KCPTRND).
    • Current Program ID: navigate to CICS workspace Program Details (KDPPRGD).
    • Task Number: navigate to ICS workspace Details for Transaction Task (KCPTASD).
    T Thread Detail SQL Text (KDPTSQLT)
    The SQL statement that a DB2 thread is currently executing.
    W Thread Detail Class 3 (KDPTHRD3)
    The accounting class 3 wait times for a selected thread.
    X Multi-thread Cancel No Confirm
    Cancel multiple threads without being prompted individually to confirm each thread cancellation.