SQLCODE = -440, ERROR: NO AUTHORIZED PROCEDURE NAMED

Article Id: 7387
Status: Published
Updated On: 14-02-2018 08:18
Legacy Id: TEC1822925
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 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:

 

A future explain gets the following SQL error:QLCODE = -440, ERROR:  NO AUTHORIZED PROCEDURE NAMED

[email protected] HAVING COMPATIBLE ARGUMENTS WAS FOUND. What's wrong?

 

 

 

Environment:

Release:
Component: PPADB2

Resolution:

User profile has Use Stored Porc. for Explain===> Y prompting the generation of SPEXPL=(Y) card on the explain. User didn't complete the post instal set up of the stored procedures. Turning off Use Stored Proc. for Explain(From Y to N) resolved the problem.