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

book

Article ID: 131908

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Sysview for DB2 encounters PTT1130E UNAUTHORIZED REQUEST. PLAN SECURITY CHECK FAILED
FOR PLAN PTTF1900 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 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.

Environment

Release:
Component: IDB2

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 DC's ID when granting execute authority on plan PTTFxxxx.