Re: Let me be the first

Mark Jamison wrote: > > Ok, after talking with my DB2 expert, I understand what your problem is. > > DB2, and other DB's let you set your lock timeout value at the > instance/database level. > > Informix gives you the same functionality, only at the client level. > > Informix's defualt lock mode is NOT WAIT. > > What that means in the scenario you gave is that the the second > application would error out as soon as it hit a row the batch process > uses. > > > The solution is to take advantage of Informix' SET LOCK MODE syntax. > > SET LOCK MODE TO WAIT 30;> > for example tells your applicatoin to try and obtain a lock for 30 > second before reporting a locking issue. In normal situations 30 > seconds is more than enough time, but on batch intensive boxes, I > have seen some apps set their lock mode as high as 120. > > > I have not problem with waiting. The batch process diferent rows from that the second user wants to read! I mean I understand locking in Informix quite well. And I see it quite impractical in combination with transactions. Only row versioning may solve my problem. Lukas