OT: IDS 10 QPlan sanity failure problems
Just like Neil, we're preparing to migrate our v9.40 servers to v10.
I already converted one test instance to v10UC3R1, using same dbspaces, the
same onconfig, sqlhosts etc.
Upgrade went fine, at least the log said so, but now we're constantly
facing -640 QPlan sanity failure <line-number> exceptions.
UPDATE STATISTICS doesn't help.Any ideas?
Thanks everyone.
"Neil Truby" <neil.truby@ardenta.com> wrote in message
news:3p6df9F8or2fU1@individual.net...
> IDS 10.0FC3 on Solaris 2.9
>
> This is a brand new server which we are preparing to migrate a v9 system
> to.
> Over the past few weeks I have run multiple dbimports from more-or-less
> the
> same data source - certainly the same schema - but the import time varies
> widely.
what update statistics did you run
If you didn't specify "for procedure" it would not have updated the
query plans for the procedure
Personally, I'd drop and recreate the procedure.
from the new techinfo (search for "Qplan" and check "Solve a problem")
Error 640 running stored procedure (SP) after database server upgrade
Technote (FAQ)
Problem
When you try to run a stored procedure you get an error -640 after
upgrading Informix Dynamic Server
Cause
Solution
PROBLEM
If you try to run a stored procedure (SP) after upgrading your database
server, you might get error -640.
-640
QPlan sanity failure line-number
CAUSE
Corruption in the SP query plan causes the -640 error.
This error occurs when the database server tries to read and build a SP
query plan, or read the constructed query plan and store it in a binary
format.
Important note: There are other possible causes for this problem. If
this document does not solve your problem, search for other documents
with the same problem. If you can't find any then contact your local
technical support office.
SOLUTION
Run the following command for a selected database:
UPDATE STATISTICS FOR PROCEDURE;