Re: Cannot DROP database

onstat -uk may give the answer; may be the btcleaner thread is holding a lock.or indeed ER Superboer "Obnoxio The Chav" <obnoxio@serendipita.com> wrote in message news:<1110224308.fd9e2f6fc3e80fe1d782e548b79254ec@teranews>... > scottishpoet said: > > 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 > > I saw the -g ses, but not the -g sql -- maybe he's got the database open > in dbaccess when trying to drop it? > > -- > > 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