Support For Native SQL Stored Procedure NSP defined with AUTONOMOUS parameter
book
Article ID: 76485
calendar_today
Updated On:
Products
CA Bind Analyzer for DB2 for z/OSCA DetectorCA SQL-Ease for DB2 for z/OSCA Sysview Performance Management Option for DB2 for z/OSCA Database Detector for DB2 for z/OSCA Plan Analyzer for DB2 for z/OSCA Subsystem 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.