Users unable to term threads

Products

• RC Compare for DB2 for z/OS
• Database Analyzer for DB2 for z/OS
• Fast Unload for DB2 for z/OS
• Fast Check for DB2 for z/OS
• Fast Index for DB2 for z/OS
• Rapid Reorg for DB2 for z/OS

Issue/Introduction

Problem: 

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.

Environment:  

Z/OS

Cause: 

 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.

Resolution/Workaround:

 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

Additional Information:

None

Environment

Release:
Component: PTT