Sysview for DB2 encounters PTT1130E UNAUTHORIZED REQUEST PLAN SECURITY CHECK FAILED FOR PLAN PTTF1900 RC=00000004-00F30034 attempting to cancel threads
Article ID: 131908
CA Bind Analyzer for DB2 for z/OSCA DetectorCA SQL-Ease for DB2 for z/OSCA Sysview Performance Management Option for DB2 for z/OSCA Database Detector for DB2 for z/OSCA Plan Analyzer for DB2 for z/OSCA Subsystem Analyzer for DB2 for z/OS
Sysview for DB2 encounters PTT1130E UNAUTHORIZED REQUEST. PLAN SECURITY CHECK FAILED FOR PLAN PTTF1900 RC=00000004-00F30034 when attempting to cancel threads.
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 DC 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 ID were being used to issue the cancel, and that ID had not been granted execute authority on the PTTFxxxx plan.
Release: Component: IDB2
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 DC's ID when granting execute authority on plan PTTFxxxx.