Re: Concurrency between processes

On Wed, 18 Dec 1996 09:08:25 GMT, PROJECT Yakov Berkovitch 3351 <berko@cpm.elex.co.il> wrote: >I'm perhaps wrong so i'm ready to get any corrections. > >Our problem is the high concurrency between processes and the >application has a big amount of update (several updates or insert per >second). > >First we didn't use the mechanism of 'CURSOR FOR UPDATE' when updating >or deleting rows. > >So an update was directly performed throw prepare/execute statments. > >Also we are working with a committed read isolation and a locking level >to row, and a lock mode wait 90. The informix release is 5.03. > >When 2 processes are trying to update the same table (and it's never the >same row !!!), the second process failed with one of the following >errors 244, 245, 246, 346. And this process that failed NEVER wait for >the 90 seconds. Is it a normal comportment, normal feature ???? > Hi Yakov, I think you have deadlock between processes. Check ISAM error. Try to use unique index when you make update or delete rows. Oleg Tretyakov tov@inist.ru