Occasionally, user loses authorities to terminate threads on some SYSVIEW systems. The following are displayed in the Xmanager Log:
PTT1098I THE FOLLOWING COMMAND EXECUTED AT 13:26:12 ON 2015-10-27 BY USER A0280052 FOR DTWB.
PTT1036I INPUT: CANCEL PLAN=DISTSERV CONN=SERVER CORR="AQT.EXE " AUTH=A02800
PTT1063I EXECUTING DB2 COMMAND: -CANCEL THREAD( 29099)
PTT1062E ERROR PROCESSING DB2 COMMAND CALL. DB2 RETURN CODE 32 REASON CODE FFFFFF
PTT1061I DSN9016I -DTWB '-CANCEL THREAD' COMMAND REJECTED, UNAUTHORIZED REQUEST
PTT1061I DSN9023I -DTWB DSN9SCND '-CANCEL ' ABNORMAL COMPLETION
PTT1031I CANCEL(CMD) ISSUED FOR THREAD: PLAN=DISTSERV CONN=SERVER CORR=aqt.exe
JOB MSGLEVEL=1 STC64064
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's not working any more.
This symptom appears when the user ID does have the authority to execute the PTT Plan but doesn't have the authority to issue a DB2 Cancel Command.
This symptom appears when the user ID does have the authority to execute the PTT Plan but doesn't have the authority to issue a DB2 Cancel Command. In order to issue a DB2 CANCEL command, a user ID must have SYSADM, SYSCTRL, or SYSOPR