One of Sysview for Db2 data collectors encountering failure PTT1130E UNAUTHORIZED REQUEST PLAN SECURITY CHECK FAILED FOR PLAN PTTFxxxx RC=00000004-00080008 DBG72034I when cancelling a thread via PTT
search cancel

One of Sysview for Db2 data collectors encountering failure PTT1130E UNAUTHORIZED REQUEST PLAN SECURITY CHECK FAILED FOR PLAN PTTFxxxx RC=00000004-00080008 DBG72034I when cancelling a thread via PTT

book

Article ID: 12435

calendar_today

Updated On:

Products

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

Issue/Introduction

Within a Db2 data sharing group, the Sysview Performance Management Option for Db2 for z/OS (IDB2) data collector for one member
of the data sharing group is not able to cancel threads that encounter an IQL exception. The IDB2 data collectors reside on different LPARS,
but have the same exact SYSCTRL authority, and each IDB2 data collector userid has execute access to the PTT (Thread Terminator)
plans (including PTTFxxxx). The failure exists even when the PTTFxxxx has been granted execute authority to PUBLIC.

The one IDB2 data collector can successfully cancel threads, but the other encounters:
PTT1130E UNAUTHORIZED REQUEST. PLAN SECURITY CHECK FAILED FOR PLAN PTTFxxxx RC=00000004-00080008
PTT API RETURNED RC= 8 RSN= 8

Resolution

Review of the Xmanager job log (residing on the same LPAR as the IDB2 data collector encountering the failure), the following Top Secret error message was found:

TSS7100E 006 J=xxxxxxxx A=xxxxxxxx T=N/A F=PTXMAN - Facility Not Authorized PXM0315 RACROUTE VERIFY FAILED SAFRC=X'0008'  
            RC=X'001C'  RS=X'00000000' USER=xxxxxxxx PLAN=PTTFxxxx 

Xmanager needs to be properly configured to Top Secret.

Using Top Secret as your security system, you must assign the Xmanager started task to a facility and grant access to the facility to all product users
(including userids associated with products like IDB2).

Review and execution of the External Security setup between the Xmanager and Top Secret will prove corrective to this failure condition.