Displaying thread status

Use the Display Thread window to show the current status of one or more threads. A DB2 thread is either an allied thread, a database access thread, or a parallel task thread. Distributed threads are those threads that have a connection with a remote location (active or inactive) or that had a connection with a remote location (indoubt). An allied thread and a parallel task thread can be distributed or nondistributed; a database access thread is always distributed.

Authorities and privileges

To display thread status:

  1. Open the Display Thread window.

  2. In the Thread type check box, select the type of threads to show. You can specify Active, Inactive or Indoubt threads, or any combination of active and inactive threads with indoubt threads.

  3. If you want to restrict the threads displayed to a specified name clear All Connections check box.

    4. In the Connection name field, type a connection name qualifier or a partial name. If you type a partial name, you are selecting the connections that begin with string and can end with any string, including the empty string. For example, CICS* selects all connection names that begin with the string CICS. Type an asterisk to display all threads in all address spaces attached to DB2 and all database access threads of the types specified.

  4. Click OK to show the status of the specified threads.

Related information