RE: cannot drop index

Posted in 2004

Bill Dare — Thu, 15 Apr 2004 14:39:28 -0400 — source: Usenet: comp.databases.informix

There could still be users accessing the table. I don't know how to find out who they are, but onstat -t wil give you a count in the ucnt column. Regards, Bill > -----Original Message----- > From: malcolm.weallans@btopenworld.com > [SMTP:malcolm.weallans@btopenworld.com] > Sent: Thursday, April 15, 2004 12:14 PM > To: informix-list@iiug.org > Subject: cannot drop index > > I am having problems dropping an index. The system complains that I > don't have exclusive access, but there are no locks on the index or > the table. > > Any ideas? > > Malcolm sending to informix-list