Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.