SQLCODE = -440 ERROR NO AUTHORIZED PROCEDURE NAMED executing Plan Analyzer explain
search cancel

SQLCODE = -440 ERROR NO AUTHORIZED PROCEDURE NAMED executing Plan Analyzer explain

book

Article ID: 7387

calendar_today

Updated On:

Products

Plan Analyzer for DB2 for z/OS Plan Analyzer for DB2 for z/OS

Issue/Introduction

A Plan Analyzer for Db2 for z/OS (PPA) future explain gets the following SQL error:

SQLCODE = -440, ERROR:  NO AUTHORIZED PROCEDURE NAMED
PTI.PPC@EXE1 HAVING COMPATIBLE ARGUMENTS WAS FOUND

Resolution

The PPA User profile had Use Stored Proc. for Explain===> Y prompting the generation of SPEXPL=(Y) card on the explain.
Site did not complete the required Post Install setup of the stored procedures. Turning off Use Stored Proc. for Explain (from Y to N)
resolved the problem.