Re: Debugging ODBC

[CRPence <CRPbottle@xxxxxxxxx>]

  But of course the stored plans are _supposed_ to be rebuilt as 
required, irrespective of the storage location, be it a package, 
program, or view.  The -901 is a generic error which is generally 
indicative of a defect.  Conditions encountered should generally not 
result in that catch-all error; in general a more specific sqlcode or 
functional outcome would be expected.  Just because the plan is old, it 
should not result in the SQL0901, the outcome should have been instead 
that the access plan simply should have been rebuilt.  The deleting of 
the package is simply an easy way to ensure that the statement gets a 
new plan, by simply ignoring the problem.  That is a lesser impact than 
an IPL to recover, but effectively the same genre if offered or chosen 
as recovery; but who really wants to collect the doc and report the 
problem with such an easy circumvention, especially if seen almost only 
after an upgrade.?

Regards, Chuck

Elvis Budimlic wrote:
> As I suspected, it was QZDAPKG database host server sql package
> (seen this before). 
> You'd think that system would unconditionally rebuild QZDAPKG
> after the OS upgrade, since all access plans stored in the package
> ought to be invalidated by the OS upgrade.