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 12 (T Active Threads) and press Enter.
    The Db2 Active Threads panel (KDPTHD52) shows the following tabs:
    Active Threads
    Shows information about Db2 Active Threads. Click Show/Hide IDLE threads to show or hide IDLE 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 (KDPTHDBP)
    View information about buffer pools for an active thread.
    D Thread Detail Distributed (KDPTHDD2 or KDPTHDDD)
    View information about the VTAM APPC conversations and TCP/IP conversations of a distributed (DDF) thread.
    If you select a thread that has only one location, location details are displayed in the KDPTHDD2 workspace.
    If there are multiple locations associated with a selected thread, a list of locations is displayed in the KDPTHDD2 workspace. To view details, select a location from the list. Details for the selected location are then displayed in the KDPTHDDD workspace.
    G Thread Detail Group Buffer Pool (KDPTHGBP)
    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 text and details that a Db2 thread is currently executing.
    K Thread Detail Package (KDPTHSPK)
    View Db2 package level accounting information.
    U Thread CICS Connection (KDPTHCIC)
    Display CICS connection information for a CICS thread.
    W Thread Detail Class 3 (KDPTHRD3)
    The accounting class 3 wait times for a selected thread.
    X Multi-thread Cancel No Confirmation
    Cancel multiple threads without being prompted individually to confirm each thread cancellation.
    M More Options (KDPTCMOR)
    Display the Options Menu panel to view more workspace options.
    E Thread Detail Enclave (KDPTHDE2)
    View information about the workload manager (WLM) enclave service periods.
    R Thread Detail RES Limit (KDPTHRDR)
    View resource limit details for a selected thread.
    F Run Application Trace (KDPATQUE)
    Start ATF to analyze performance-related details about this thread.
    Because this is a workspace redirect (silent workspace), when ATF ends or start request is canceled, control will return to the thread summary workspace (DSG or single Db2).
    V Run EXPLAIN
    Run EXPLAIN for a Db2 thread.