Re: 211 error on sysprocplan
This stores the query plan and environment variable setting of PDQPRIORITY
for a stored procedure. When you create a stored procedure, the query plan
is created and stored in this table and when the SPL is executed it simply
uses the plan. Update stats of the procedure, drops/recreates the plan for
the SPL.
Thanx much,
Rajib Sarkar
Advisory Software Engineer (RAS)
IBM Data Management Group
Ph : (602)-217-2100
Fax: (602)-217-2100
T/L : 667-2100
As long as you derive inner help and comfort from anything, keep it --
Mahatma Gandhi
Jane Vohden
<jvohden@co.fairb To: "'informix-list@iiug.org'" <informix-list@iiug.org>
anks.ak.us> cc:
Sent by: Subject: 211 error on sysprocplan
owner-informix-li
st@iiug.org
09/18/2003 12:27
PM
We recently experienced a -211 error referencing the sysprocplan table in
the system catalog. I ran the oncheck utility and it didn't report any
problems in the database but the system is working fine again now.
Anyway - I could not find any information about the sysprocplan table. Can
anyone tell me where it is documented? Or what it's purpose is? Thank
you. - Jane Vohden
Jane Vohden
Database Administrator
Fairbanks North Star Borough
sending to informix-list