Cannot drop database

Hi, I'm running IDS 7.30 on RedHat Linux 6.0 with ClientSDK 2.10.UC3 and have created the following problem: I cannot drop a database. I was testing a Java application on a Win95 machine using JDBC to insert records into a table in this database when the process hung. I stopped the Java process and then tried to drop the database. I got two errors - I only remember one of the -107 ( ISAM error: record is locked ). I shut IDS down then restarted it but...if I try to drop the database from dbaccess I now get Running . . . at the bottom of the screen forever. Where do I go from here? Thanks

Edward Ellert wrote: > Hi, > > I'm running IDS 7.30 on RedHat Linux 6.0 with ClientSDK 2.10.UC3 and > have created the following problem: > > I cannot drop a database. > > I was testing a Java application on a Win95 machine using JDBC to insert > records into a table in this database when the process hung. I stopped > the Java process and then tried to drop the database. I got two errors > - I only remember one of the -107 ( ISAM error: record is locked ). I > shut IDS down then restarted it but...if I try to drop the database from > dbaccess I now get Running . . . at the bottom of the screen forever. > > Where do I go from here? > > Thanks Try oncheck -- Compliments of QueriX -------------------------------------------------------------------------------------------------- QueriX 4GL Compilers are Informix 4GL Compatible, and Connection to other RDBMS such as Oracle. Hydra 4GL Compiler Compile once, run everywhere Phoenix Windows GUI. Chimera Java GUI The only GUI you will ever need... Arachne Web Technology For more details visit: http://www.querix.com/ ---------------------------------------------------------------------------------------------------

Edward Ellert wrote: > > Hi, > > I'm running IDS 7.30 on RedHat Linux 6.0 with ClientSDK 2.10.UC3 and > have created the following problem: > > I cannot drop a database. > > I was testing a Java application on a Win95 machine using JDBC to insert > records into a table in this database when the process hung. I stopped > the Java process and then tried to drop the database. I got two errors > - I only remember one of the -107 ( ISAM error: record is locked ). I > shut IDS down then restarted it but...if I try to drop the database from > dbaccess I now get Running . . . at the bottom of the screen forever. > > Where do I go from here? Sounds like you interrupted a drop database in the middle on a database that was created without logging. You may be hosed. Try oncheck as Mehdi suggests and if all else fails call tech support who will have to login and irradicate the remaining bits and pieces of your half dropped database. Art S. Kagel

you need to have exclusive access to the database in order to drop it. I usually restart the engine and then drop. ----- Original Message ----- From: Edward Ellert <edward.s.ellert@lerc.nasa.gov> To: <comp.databases.informix@list.deja.com> Sent: Thursday, December 16, 1999 9:48 AM Subject: Cannot drop database > Message from the Deja.com forum: > comp.databases.informix > Your subscription is set to individual email delivery > > > Hi, > > I'm running IDS 7.30 on RedHat Linux 6.0 with ClientSDK 2.10.UC3 and > have created the following problem: > > I cannot drop a database. > > I was testing a Java application on a Win95 machine using JDBC to insert > records into a table in this database when the process hung. I stopped > the Java process and then tried to drop the database. I got two errors > - I only remember one of the -107 ( ISAM error: record is locked ). I > shut IDS down then restarted it but...if I try to drop the database from > dbaccess I now get Running . . . at the bottom of the screen forever. > > Where do I go from here? > > Thanks > > > > > _____________________________________________________________ > Deja.com: Before you buy. > http://www.deja.com/ > * To modify or remove your subscription, go to > http://www.deja.com/edit_sub.xp?group=comp.databases.informix > * Read this thread at > http://www.deja.com/thread/%3C3858FBCD.11930A2E%40lerc.nasa.gov%3E > > Sent via Deja.com http://www.deja.com/ Before you buy.