Support For Native SQL Stored Procedure NSP defined with AUTONOMOUS parameter

Article Id: 76485

Status: Published

Updated On: 10-05-2018 14:08

Products:

CA Bind Analyzer for DB2 for z/OS , CA SQL-Ease for DB2 for z/OS , CA Sysview Performance Management Option for DB2 for z/OS , CA Plan Analyzer for DB2 for z/OS , CA 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.