SQLCODE = -440, ERROR: NO AUTHORIZED PROCEDURE NAMED
book
Article ID: 7387
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
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.