A future explain gets the following SQL error:QLCODE = -440, ERROR: NO AUTHORIZED PROCEDURE NAMED
PTI.PPC@EXE1 HAVING COMPATIBLE ARGUMENTS WAS FOUND. What's wrong?
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.
Was this information helpful?