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

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.