ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

SQLCODE = -440, ERROR: NO AUTHORIZED PROCEDURE NAMED

book

Article ID: 7387

calendar_today

Updated On:

Products

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