ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Insight explain receiving DBG55096E

book

Article ID: 53181

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer 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 Fast Load for DB2 for z/OS Rapid Reorg for DB2 for z/OS

Issue/Introduction

Description:

User receives the DBG55096E message while trying to explain an SQL statement for an active thread:
DBG55096E &ZUSER-&ZGROUP, function restricted by security
+The operation was terminated by security checking.

Solution:

The User profile associated with the User's id in the security file had EXPLAIN=TSO. Recommended changing the setting to EXPLAIN=ALL. After user exited Insight, client would then use the SECURITY command in Insight to do a refresh of security. Next time User invoked Insight, they were able to successfully execute an explain.

Environment

Release:
Component: IDB2