Re: OnLine 5.06 Locking Query

Posted in 1996

Topics: Server Administration, Transactions, Locking & Isolation

rajivp@qsun2.ho.att.com — 23 Aug 1996 10:58:05 -0400 — source: Informix-list mailing list archive (1991-1998)

> From rmy.emory.edu!informix-list-owner@kcig2.att.att.com Fri Aug 23 09:47:56 1996 > >Received: by kcgw2.att.com; Fri Aug 23 08:41 CDT 1996 > From: Sally Woolrich <sally@excelsis.co.uk> > Subject: OnLine 5.06 Locking Query > Sender: informix-list-owner@rmy.emory.edu > To: informix-list@rmy.emory.edu > X-Informix-List-To: rajivp@qsun.ho.att.com > X-Informix-List-Id: <news.27380> > Content-Type: text > > I have been told that deleting a unique key from a table locks the > *whole* table! Any comments on this? > > TIA > > -- > Sally Woolrich > > Sally, This can be true if An exclusive lock is placed on the table using LOCK TABLE before starting a delete. If the table has PAGE level locking then that all the rows on that page would be locked when the delete is in progress. At least this is what I think should happen, but I may be in for a suprise on this one. -- Rajiv Jhaveri DBA ================================================================= Voice : (908) 949 7987 Pager : 544 7872 or 1-800 225 0256 PIN 310902 Fax : (908) 949 1726 E-mail: rajivp@qsun.ho.att.com =================================================================