Re: Problem: cannot drop database.

Posted in 1996

tolly brumbelow — Fri, 22 Mar 1996 19:44:41 GMT — source: Informix-list mailing list archive (1991-1998)

Mark Oberfield <oberfiel@thunder.nws.noaa.gov> wrote: >While doing spring cleaning this afternoon, I have run into the >following >problem in dropping an old database as user INFORMIX: >SQLCODE = -214: Cannot remove file for table (). >The ISAM code is -106 >ISAM message: ISAM error: non-exclusive access. >I have dropped all of its tables, so the database is empty. SYSTABLES >show no tabid > 100 and no one is attached to the database. >The Online Engine is Version 5.03.UC1. >Is this database going to be a "tar baby"? What have I overlooked? >mgo It appears from the error your getting someone else has a lock on the database. lock the database in exclusive mode and then issue the drop and see what happens. You can issue one of tbstat commands to check for locks. -- Tolly Brumbelow, Informix DBA email:tolly.brumbelow@bridge.bellsouth.com