Re[2]: SYSPROCPLAN locked using Stored Procedures

We had major problems with this a while back=2E I eventually traced i= t=20 to the engine updating stats for a procedure when you execute the proc= =20 if a table in that proc has changed=2E It's actually in a manual=20 somewhere=2E If the proc is executed in a transaction, then exclusive= =20 locks are placed on all the sysprocplan rows for that proc=2E Our=20 solution was to update stats for procedures as a separate routine=20 AFTER the rest of the database has had its stats updated=2E =20 Davin ______________________________ Reply Separator ____________________________= _____ Subject: Re: SYSPROCPLAN locked using Stored Procedures Author: PC {djw@smooth1=2Edemon=2Eco=2Euk} at INTERNET Date: 14/11/97 21:24 In article <19971114172201=2EMAA27613@ladder02=2Enews=2Eaol=2Ecom>, DRSante= e=20 <drsantee@aol=2Ecom> writes >We are using 16 bit PowerBuilder 5=2E02 connecting through its native driv= er=20 > using I-Net 5=2E01=2EWJ2 executing a stored procedure on Informix Online=20 5=2E06=2EUC2=2E > Occassionally (we can not reproduce at will or with any consistency yet)= =20 the > SYSPROCPLAN table becomes locked and gives a second user an SQL -211 erro= r=2E=20 > =20 There was a bug in Online where locks were held on sysprocplan=2E =20 Upgrade to the latest version (I run 5=2E08 and I think later versions=20 are available)=2E =20 >Danny Santee >City of Aurora >Aurora, Co >dsantee@ci=2Eaurora=2Eco=2Eus =20 --=20 David Williams =20 ********************************************************************** DST International Tel:+44 181 390 5000 www=2Edstinternational=2Eco=2Eu= k=20 This message and any attachments to it is intended only for the=20 individual or company to which it is addressed and may contain=20 information which is privileged, confidential or prohibited from=20 disclosure or unauthorised use=2E If the recipient of this=20 transmission is not the intended recipient, or the employee or agent=20 responsible for delivering such materials to the intended recipient,=20 you are hereby notified that any use, any form of reproduction,=20 dissemination, copying, disclosure, modification, distribution and/or=20 publication of this e-mail message or its attachments other than by=20 its intended recipient is strictly prohibited by the sender=2E =20 If you have received it in error, please notify us immediately by=20 telephone on the number above and destroy the message and all copies=20 in your possession=2E **********************************************************************