Support For Native SQL Stored Procedure NSP defined with AUTONOMOUS parameter
searchcancel
Support For Native SQL Stored Procedure NSP defined with AUTONOMOUS parameter
book
Article ID: 76485
calendar_today
Updated On: 05-10-2018
Products
Bind Analyzer for DB2 for z/OSSQL-Ease for DB2 for z/OSSYSVIEW Performance Management Option for DB2 for z/OSPlan Analyzer for DB2 for z/OSSubsystem Analyzer for DB2 for z/OS
Issue/Introduction
User complained about the Native SQL Stored Procedure (NSP) defined with the AUTONOMOUS parameter not showing up in Release 18 of Insight. The AUTONOMOUS NSP is showing up in the DB2 Accounting records, so there appears to be a defect in the CA Tools R18.
Environment
Release: Component: IDB2
Resolution
Support for Native SQL Stored Procedure NSP defined with AUTONOMOUS parameter is available in R19 and up.