Re: Error 271

ramajig@aol.com (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 You are right about the adjacent row locking problem is removed in ver. 7. However I seem to remember somthing about some bug related to this in 7.something. If knowone else comes up with an answer simply call your Informix support. They should be able to find out if there is one. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company