Problem while working with different users.
Hi Informix users, I have a problem while two or more people are working (writing and updating) on the same tables. I get the error message -244 Could not do a physical-order read to fetch next row. So I suppose that when one user uses the table, the other can't reach it. Is there a parametre, setting that avoids such problem? I already changed the lock mode of the table to lock mode row. I use a OWS 7.31.UC2 database. Thanks, Danny
Try setting the lock mode to wait 5. (This is an application parameter, though, not an engine configuration parameter.) In article <8qclm3$2oac$1@rivage.news.be.easynet.net>, "Danny De Koster" <Fidelity@fidelity-soft.be> wrote: > This is a multi-part message in MIME format. > > ------=_NextPart_000_0008_01C023C2.218FBE70 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > Hi Informix users, > > I have a problem while two or more people are working (writing and = > updating) on the same tables. > I get the error message -244 Could not do a physical-order read to fetch = > next row. > So I suppose that when one user uses the table, the other can't reach = > it. > Is there a parametre, setting that avoids such problem? I already = > changed the lock mode of the table to lock mode row. > > I use a OWS 7.31.UC2 database. > > Thanks, > Danny > > ------=_NextPart_000_0008_01C023C2.218FBE70 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META content=3D"text/html; charset=3Diso-8859-1" = > http-equiv=3DContent-Type> > <META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR> > <STYLE></STYLE> > </HEAD> > <BODY> > <DIV><FONT face=3DArial size=3D2>Hi Informix users,</FONT></DIV> > <DIV> </DIV> > <DIV><FONT face=3DArial size=3D2>I have a problem while two or more = > people are=20 > working (writing and updating) on the same tables.</FONT></DIV> > <DIV><FONT face=3DArial size=3D2>I get the error message -244 = > </FONT><EM>Could not=20 > do a physical-order read to fetch next row</EM>.</DIV> > <DIV>So I suppose that when one user uses the table, the other can't = > reach=20 > it.</DIV> > <DIV>Is there a parametre, setting that avoids such problem? I already = > changed=20 > the lock mode of the table to <EM>lock mode row</EM>.</DIV> > <DIV> </DIV> > <DIV> </DIV> > <DIV>I use a OWS 7.31.UC2 database.</DIV> > <DIV> </DIV> > <DIV>Thanks,</DIV> > <DIV>Danny</DIV></BODY></HTML> > > ------=_NextPart_000_0008_01C023C2.218FBE70-- > > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.
Danny De Koster wrote: > Hi Informix users, I have a problem while two or more people are > working (writing and updating) on the same tables.I get the error > message -244 Could not do a physical-order read to fetch next row.So I > suppose that when one user uses the table, the other can't reach it.Is > there a parametre, setting that avoids such problem? I already changed > the lock mode of the table to lock mode row. I use a OWS 7.31.UC2 > database. Thanks,Danny > > Getting the ISAM error does help in problem determination. You are almost certainly correct on your assumption. You can do SET LOCK MODE TO WAIT n where n is the number of seconds you are willing to wait. It is still possible you are getting deadlock errors(The ISAM code will tell you), in which case you need to decide whether you want the program to abort, or try to do whatever it was doing again. Hope this helps, Will