DBG55096E - Function restricted by security

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
• Rapid Reorg for DB2 for z/OS

Issue/Introduction

Description:

Using Insight's VTAM User Interface, and attempting to use the EXPLAIN process, the following error message is encountered:

DBG55096E - Function restricted by security.

Solution:

Changing the EXPLAIN= parameter in Insight's Security file from EXPLAIN=TSO to EXPLAIN=ALL, and then rebinding the IDB2's plans/packages followed by bouncing the Insight Data Collector resolved the DBG55096E condition.

Environment

Release:
Component: IDB2