Re: Cannot DROP database

kadu said: > Hello, > I'm really new in informix world and I have I think easy question... > > So I need drop db from current dbspace and recreate it in new dbspace. > I've created new dbspace with onspaces, got dbexport on another server > and now need dbimport it. > > But... > > informix@czhs0300: onstat -g sql > > Informix Dynamic Server Version 7.31.UD7 -- On-Line -- Up 00:10:35 > -- 372392 Kbytes > > informix@czhs0300: onstat -g ses > > Informix Dynamic Server Version 7.31.UD7 -- On-Line -- Up 00:10:39 > -- 372392 Kbytes > > session #RSAM total used > id user tty pid hostname threads memory memory > 30 informix - 0 - 0 8192 5320 > 8 informix - 0 - 0 8192 5320 > 7 informix - 0 - 0 16384 13856 > 6 informix - 0 - 0 8192 5320 > 4 informix - 0 - 0 16384 13856 > 3 informix - 0 - 0 8192 5320 > 2 informix - 0 - 0 8192 5320 > > when i'm dropping cah with dbaccess->Databases->Drop->db name then YES > > This error appears > > 425: Database is currently opened by another user. > 107: ISAM error: record is locked.> > > This make me consfused ... Nobody is using it! Trust me, someone, somewhere is connected to that database. what does the output from "onstat -g sql" say? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco Travel broadens a person. You look as if you have been all over the world. I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed http://members.rogers.com/2remedy/images/smilies/banners/RTFM.gif sending to informix-list

obnoxio the output on onstat -g sql is apparently posted in the original post... informix@czhs0300: onstat -g sql Informix Dynamic Server Version 7.31.UD7 -- On-Line -- Up 00:10:35 -- 372392 Kbytes informix@czhs0300: onstat -g ses Informix Dynamic Server Version 7.31.UD7 -- On-Line -- Up 00:10:39 -- 372392 Kbytes session #RSAM total used id user tty pid hostname threads memory memory 30 informix - 0 - 0 8192 5320 8 informix - 0 - 0 8192 5320 7 informix - 0 - 0 16384 13856 6 informix - 0 - 0 8192 5320 4 informix - 0 - 0 16384 13856 3 informix - 0 - 0 8192 5320 2 informix - 0 - 0 8192 5320