Re: sysprocplan

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 =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--