RE: Dropping a database that has 214: Cannot remov

IDS 9.4 Linux RedHat Enterprise 4 echo "drop database otss" | dbaccess sysmaster >>> >>> Database selected. >>> >>> 214: Cannot remove file for table >>> (idsdb.dbd_ix_udts). >>> Error in line 1>>> Near character position 18 >>> >>> Database closed. I check permissions for this table and as informix (DBA), I have full permissions. so it is not a permissions issue. What are my options for dropping this database from a multi-database instance? Larry

Do this in an interactive dbaccess session so you can keep the session open after the error and see the ISAM level error in the onstat -g ses <sessid> report. The ISAM error will tell us more about what's causing the error. Also, post the contents of the systables or sysindices record for this table or indecx (idsdb.dbd_ix_udts). I wonder what file the server could be talking about. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Mar 2, 2010 at 8:59 PM, Larry Sorensen <lsorensen25@msn.com> wrote: > IDS 9.4 Linux RedHat Enterprise 4 > > echo "drop database otss" | dbaccess sysmaster > >>> > >>> Database selected. > >>> > >>> 214: Cannot remove file for table > >>> (idsdb.dbd_ix_udts). > >>> Error in line 1> >>> Near character position 18 > >>> > >>> Database closed. > > I check permissions for this table and as informix (DBA), I have full > permissions. so it is not a permissions issue. > > What are my options for dropping this database from a multi-database > instance? > > Larry > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000325554592ecfe030480dc7832