Re: Locking...

On 4 Dec 96 at 20:34, Mik Hobbs wrote: > I've worked on a number of large multi-user informix databases and where > there are a number of users inserting / updating data in a table it has > always been necessary to have row level locking. > > It's not correct to state that row level locking only locks the row > you're updating, it could also lock adjacent rows where an index is > affected. With large volumes you could get -271, -245 & -246 errors. > Setting 'lock mode wait' should avoid these errors. This is only in 5.x, isn't it? I'm sure DSA doesn't lock adjacent rows... -- Ciao, Billy I'd be in favour of apathy, but I just couldn't be bothered...