Re: Error 271

Ramajig wrote: > > I'm using V7.11 of Informix on AIX platform with about 4GB of DB size. > While accessing an indexed table, I sometime receive error 271. The error > manual specifies that the row may be locked. I do find that the key next > to what I access is in a lock state caused by another user. I thought > that this adjacent row locking was a problem in Informix V5.x and not in > the later version(Least I expect it to be in V7.x !) The lock level of the > table is set to row and isolation level is set to repeatable read. > Am I to do anything more to resolve the error? > Anticipating a possible solution. > Thank you I assume you were trying to update the table when you get error 271. For "Repeatable Read", the user has locks on all the rows fetched, other users can only read records if it's a ordinary cursor, or can't read any rows if it's a update cursor. You can find more detailed information about repeatable read in the manual. For solution, you should look for lower isolation level, such as committed read. HTH Weimin Yang