Re: Error 271

> 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. Well, I don't know if it's a solution, but the problem probably stems from the use of repeatable read: this isolation level locks every row it *examines* to make up the cursor, not just every row in the final cursor. HTH. -- Ciao, Billy +------------------------------------------------------------------------------+ | I used to be indecisive, but now I'm not so sure... | +------------------------------------------------------------------------------+