Support For Native SQL Stored Procedure NSP defined with AUTONOMOUS parameter

Products

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