Re: sysprocplan locking problem

Hello. >From: "Weaver, Bill" <bweaver@fscorp.com> >To: "'informix-list@iiug.org'" <informix-list@iiug.org> >Subject: sysprocplan locking problem >Date: Fri, 8 Oct 1999 10:44:30 -0400 > >I have some insert/update triggers that call a stored procedure to maintain >certain data in a table. This has been in place for almost a month now and >on 3 different occassions, a process will "hang" and lock the sysprocplan >table in exclusive mode. Of course this keeps others from executing the >stored procedure as we sit in a deadlock situation. > >Does anyone know what is causing this and how to fix it? I'm running IDS >7.30.UC3. If you need additional information, let me know. > You said it, 'deadlock'. Can you post more details ?, the table with its triggers, the stored procedure, the tables the stored procedure touches, etc. Angel Gomez TelNor, S.A. Tijuana, B.C., Mexico. <Angel.Gomez@telnor.com> ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com