This document states whether or not the Thread Terminator\Dynamic DSNZPARM authority of the PTTPLN03= (Terminate Threads) plan is limited when cancelling threads.
Is the Thread Terminator\Dynamic DSNZPARM authority of the PTTPLN03= (Terminate Threads) plan limited when cancelling threads?
Generally, Thread Terminator uses a proprietary method that triggers DB2 to cancel threads, without issuing an actual DB2 CANCEL command. If someone has authority to execute the PTTPLN03= (Terminate Threads ) plan, they're able to cancel most threads. However, if the thread is either a distributed or parallel thread, a DB2 CANCEL command is issued to terminate the thread. A TSO user can issue a DB2 CANCEL command only if he/she has at least SYSOPR authority.
There’s also the “K-Terminate thread in MVS” option on the “Thread Terminator Terminate Threads” display. This option terminates the actual work unit that the DB2 thread was created under, again without issuing a DB2 CANCEL command.