Re: Cannot DROP database

kadu wrote: > 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! > > Could you help me pls? > when you run "dbaccess" do you connect to any db? You cannot connect to the db you're trying to drop. Regards.