Re: adjacent key locking

On 5 Jun 1997, Nicholas Allon wrote: > Could anyone please explain the problem of adjacent key locking when it > occurs and any possible solutions. The informix error code was -243. We are > using AIX 3.5, with informix online 7.12 What makes you think that this is adjacent row locking? Adjacent row locking, apart from being old news (fixed by 5.05 and 7.v.early I believe) was the condition where the engine would lock the row after a row being inserted, in case you were about to insert another one. This is a badly worded example, but its one of those days -- correct me if I'm wrong[0]. What's more likely is that some other process was locking the data that you were attempting to select/modify/whatever. Are you set to lock mode row? If not, then you may have ran into another problem where processes accessing physically-close data can have you locked. The majority of locking problems may be fixed with the careful application of a SET LOCK MODE TO WAIT 1 statement to the top of the code. You can increase the 1 upwards (its in seconds) but even a 1 will retry numerous times, and eliminates most of the momentary-lock type problems. -Richard [0] Not that I'd expect people not to if I did'nt ask them to...