Monitoring threads

You monitor threads by using the DB2® DISPLAY THREAD command, which displays current information about the status of threads.

About this task

Begin general-use programming interface information.
The DISPLAY THREAD command displays information about:

  • Threads that are processing locally
  • Threads that are processing distributed requests
  • Stored procedures or user-defined functions that the thread is executing
  • Parallel tasks

End general-use programming interface information.

  • Types of threads
    Threads are an important resource within a DB2 subsystem. A thread is a structure that describes a connection made by an application and traces its progress in the DB2 subsystem.
  • Output of the DISPLAY THREAD command
    The output of the DISPLAY THREAD command can also indicate that a system quiesce is in effect as a result of the ARCHIVE LOG command.
  • Displaying information about threads
    Use the DISPLAY THREAD TYPE(INDOUBT) command to find information about allied and database access indoubt threads. This command provides information about threads where DB2 is a participant, a coordinator, or both.
  • Monitoring all DBMSs in a transaction
    Use the DETAIL keyword of the DISPLAY THREAD command to monitor all of the requesting and serving database management systems (DBMSs) that are involved in a transaction.
Parent topic: Monitoring and controlling DB2 and its connections
Related tasks:
Managing DB2 threads
Related reference:
-DISPLAY THREAD (DB2)

Related information

DSNV401I