Is the Thread Terminator\Dynamic DSNZPARM authority of the PTTPLN03= (Terminate Threads) plan limited when cancelling threads?

book

Article ID: 104119

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

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?

Environment

z/OS 1.11 and above.
 

Resolution

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.