Adjacent Key locking

Posted in 1997

Denham.M@amstr.com — 5 Jun 1997 14:28:30 -0400 — source: Informix-list mailing list archive (1991-1998)

Nicholas As far as adjacent key locking is concerned, forget it. If my memory serves me correctly this was an issue with V5 and earlier engines. Not V7. I cannot of course vouch for the fact that adjacent key locking is not used in V7 SE. I am assuming that you have online. Adjacent key locking is used by the engine to ensure integrity when a index key gets deleted. This is a very basic view, I am sure someone else will give you more accurate info. Mark MarkDenham@aol.com (home) Denham.M@amstr.com (work) --------------------------( Forwarded letter 1 follows )--------------------- Date: Thursday, 5 June 1997 6:38am From: "Nicholas Allon" <ok90@dial.pipex.com> Subject: Adjacent Key locking Date: 5 Jun 1997 12:30:04 GMT Reply-To: ok90@dial.pipex.com Organization: UUNet UK server (post doesn't reflect views of UUNet UK) Sender: informix-list-owner@rmy.emory.edu To: informix-list@rmy.emory.edu X-Informix-List-Id: <news.38793> Could someone please explain the adjacent key locking problem to me, when it occurs and how to get around it. We are using Online ver 7.12 on AIX.