RE: Problem while working with different users.
set lock mode to wait <n>
Mukund Shevkar
-----Original Message-----
From: mars1972@my-deja.com [mailto:mars1972@my-deja.com]
Sent: Thursday, September 21, 2000 5:04 AM
To: informix-list@iiug.org
Subject: Re: Problem while working with different users.
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.