Sysview for Db2 encounters PTT1130E UNAUTHORIZED REQUEST PLAN SECURITY CHECK FAILED FOR PLAN PTTFxxxx RC=00000004-00F30034 attempting to cancel threads

Products

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

Issue/Introduction

Sysview Performance Management Option for Db2 for z/OS (IDB2) encounters PTT1130E UNAUTHORIZED REQUEST. PLAN SECURITY CHECK FAILED
FOR PLAN PTTFxxxx RC=00000004-00F30034 when attempting to cancel threads.

Cause

The Sysparm parameter Thread-Cancel-Authid=User (default) was being used, but the particular TSO ID's
had not been granted execute authority on the PTTFxxxx plan. When Thread-Cancel-Authid=DC was stated
the 8 byte IDB2 data collector UserID was granted execute authority on all of the PTT plans (including PTTFxxxx),
but without the PTF SO00484 applied only the first 7 bytes of the UserID were being used to issue the cancel,
and that ID had not been granted execute authority on the PTTFxxxx plan.

Resolution

With Thread-Cancel-Authid=DC specified, and without the application of IDB2 PTF SO00484 to support 8 character Userids,
it was necessary to use the first 7 bytes of the IDB2 data collector ID when granting execute authority on plan PTTFxxxx.