Users unable to term threads message PTT1061I cancel command rejected

Products

• SYSVIEW Performance Management Option for DB2 for z/OS
• Thread Terminator for DB2 for z/OS

Issue/Introduction

Occasionally a user loses authorities to terminate threads on some Sysview for Db2 for z/OS (IDB2) environments.


The following are displayed in the Xmanager Log:

PTT1098I THE FOLLOWING COMMAND EXECUTED AT 13:26:12 ON 2015-10-27 BY USER xxxxxxxx FOR ssid.

PTT1036I INPUT: CANCEL PLAN=DISTSERV CONN=SERVER   CORR="AQT.EXE     " AUTH=xxxxxxxx

PTT1063I EXECUTING DB2 COMMAND: -CANCEL THREAD(   29099)                          

PTT1062E ERROR PROCESSING DB2 COMMAND CALL.  DB2 RETURN CODE 32 REASON CODE FFFFFF

PTT1061I DSN9016I  -ssid '-CANCEL THREAD' COMMAND REJECTED, UNAUTHORIZED REQUEST  

PTT1061I DSN9023I  -ssid DSN9SCND '-CANCEL ' ABNORMAL COMPLETION                  

PTT1031I CANCEL(CMD) ISSUED FOR THREAD: PLAN=DISTSERV CONN=SERVER   CORR=aqt.exe        

 

The user has the correct authorization but on occasion loses it.  
Recycling the Xmanager has worked before to fix the problem before, but now it is not working any more.

Cause

This symptom appears when the User ID does have the authority to execute the PTT plan but does not have the authority to issue a Db2 Cancel Command.

Resolution

In order to issue a Db2 CANCEL command a User ID must have SYSADM, SYSCTRL, or SYSOPR authorization.