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.
David Williams — — source: Informix-list mailing list archive (1991-1998)
In message <s46ff706.026@kiwi.co.nz>, Peter Tashkoff
<informix@kiwi.co.nz> writes
}Sysprocplan will become locked anytime a stored procedure needs to be
}recompiled.
}This can happen if someone has released a stored procedure to live, or a
}database change has gone to live which affects a stored procedure.
}I don't know whether the poster is treating Sp changes as database changes but
}they should be.
}We take a full application outage here to release SPs.
}rgds
}
Sysprocplan is also locked when you
UPDATE STATISTICS FOR PROCEDURE <x>
I believe there was a bug where the optimizer would uneccessarily
re-optimize the procedure.
}
}
}Peter Tashkoff <tashkop@iname.com>
}Zespri International Limited Std Disclaimers Apply
}All rights reserved. No party may use this document to vilify another.
}
}Zespri New Zealand Kiwifruit, The World's Finest
}
}
}>>> David Williams <djw@smooth1.demon.co.uk> 15/11/97 07:50:04 >>>
}In article <19971114172201.MAA27613@ladder02.news.aol.com>, DRSantee
}<drsantee@aol.com> writes
}>We are using 16 bit PowerBuilder 5.02 connecting through its native driver
}> using I-Net 5.01.WJ2 executing a stored procedure on Informix Online 5.06.UC2.
}> Occassionally (we can not reproduce at will or with any consistency yet) the
}> SYSPROCPLAN table becomes locked and gives a second user an SQL -211 error.
}>
}
} There was a bug in Online where locks were held on sysprocplan.
}
} Upgrade to the latest version (I run 5.08 and I think later versions
} are available).
}
}>Danny Santee
}>City of Aurora
}>Aurora, Co
}>dsantee@ci.aurora.co.us
}
--
David Williams
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.