Re: sysprocplan

In article <6d0snu$ocn$1@news.xmission.com>, davin_harvey@dsti.co.uk writes > >This is a multipart message in MIME format > >--------------InterScan_NT_MIME_Boundary >Content-Type: text/plain; charset=ISO-8859-1 >Content-transfer-encoding: quoted-printable > > This is fast becoming one for the FAQ=2E It's already in the new FAQ on the Primary Site below... > =20 > When you execute a procedure, if any of the tables within that=20 > procedure have changed in structure, or had update statistics run on=20 > them, a new query plan for the procedure is generated=2E If done in a= >=20 > transaction, the sysprocplan rows for that procedure are locked for=20 > the duration of the transaction=2E > =20 > Therefore, if you update statistics for a table, or change a table,=20 > make sure you update stats for ALL procedures that reference that=20 > table=2E > =20 > Davin > > >______________________________ Reply Separator ____________________________= >_____ >Subject: sysprocplan >Author: PC {Leonids=2EVoroncovs@dati=2Elv} at INTERNET >Date: 24/02/98 18:20 > > >Hi, all! Help needed=2E >Two users executes statement SELECT my_field, my_proc( my_param ) FROM=20 >=2E=2E=2E and one of them geted error - "Cannot read system catalog (=20 >sysprocplan )"=2E What happens and how I can escape this situation? I must=20 >say that this situation is not stable=2E >May be INFORMIX in some cases updates this table and don't commits=20 >operation? >Best wishes=2E Leonid=2E > =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 >********************************************************************** > > >--------------InterScan_NT_MIME_Boundary-- -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care