Re: cannot drop index

--0__=09BBE4E4DFFD654D8f9e8a93df938690918c09BBE4E4DFFD654D Content-type: text/plain; charset=US-ASCII You could be having certain sessions/cursors that have opened the index partition. Check the output from onstat -g opn if any thread is having your index fragment open. Regards, Uday. owner-informix-list@iiug.org wrote on 04/15/2004 11:13:56 AM: > 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 --0__=09BBE4E4DFFD654D8f9e8a93df938690918c09BBE4E4DFFD654D Content-type: text/html; charset=US-ASCII Content-Disposition: inline <html><body> <p>You could be having certain sessions/cursors that have opened the index partition. Check the output from onstat -g opn if any thread is having your index fragment open.<br> <br> Regards,<br> Uday. <br> <br> <tt>owner-informix-list@iiug.org wrote on 04/15/2004 11:13:56 AM:<br> <br> &gt; I am having problems dropping an index. &nbsp;The system complains that I<br> &gt; don't have exclusive access, but there are no locks on the index or<br> &gt; the table.<br> &gt; <br> &gt; Any ideas?<br> &gt; <br> &gt; Malcolm<br> </tt></body></html> --0__=09BBE4E4DFFD654D8f9e8a93df938690918c09BBE4E4DFFD654D-- sending to informix-list