Canceling a thread

Follow these steps to cancel a thread.

1. On the DB2 Query Monitor main menu, type 3 in the Option field and press Enter.
2. Locate the SQL thread you want to cancel.
3. Type E in the CMD field next to the SQL activity of interest and press Enter.
   The Cancel DB2 Thread panel is displayed:

   ---------- Cancel DB2 Thread ----------
   
     The following thread is about to be canceled:      
                                                        
   JOBNAME: JOBNAME1     Plan: PLAN003   Token:   3135  
                                                        
       Cancel Thread  Y      with Dump  N   NOBACKOUT  N
                                                        
     Press Enter to cancel thread or  PF3 to exit       

4. Verify that the jobname, plan, and token that are shown on the Cancel DB2 Thread window correspond to the thread you want to cancel.
5. Type Y in the Cancel Thread field.
6. Specify whether or not you want to produce a dump when the thread is canceled.
   • Type Y in the With Dump field if you want to produce a dump when the thread is canceled.
   • Type N in the With Dump field if you do want to produce a dump when the thread is canceled.
7. Specify whether or not you want to Db2 to attempt to backout the data during transaction rollback processing.
   • Type N in the NOBACKOUT field if you want Db2 not to attempt to backout the data during transaction rollback processing.
   • Type Y in the NOBACKOUT field if you want to leave objects in an inconsistent state. You should not set this option to Y unless you plan to resolve the data inconsistency it creates. For more information, refer to the Db2 Command Reference.
8. Press Enter.