Canceling threads

Use the Cancel Thread window to terminate one or more threads that are active or suspended in DB2.

Authorities and privileges

To cancel a selected thread:

  1. Open the Display Thread window.

  2. In the Display Thread window that opens, click OK from the Display Thread window to view the active threads.

  3. Select the threads to cancel. You cannot cancel threads from this window that are not active or suspended in DB2. A database access thread can also be in the prepared state waiting for the commit decision from the coordinator.

  4. Right-click and select Cancel Thread from the pop-up menu. The Cancel Thread window opens.

  5. Click OK to end the thread. When you cancel a thread for a database access thread in the prepared state, the thread is converted from active to indoubt. The conversation with the coordinator, and all conversations with downstream participants, are terminated and message DSNL450I is returned. The resources held by the thread are not released until the indoubt state is resolved. The state is resolved automatically by the coordinator or by using RECOVER INDOUBT.

Related information