Re: Can't drop database??? WHY???

WF Software wrote: > > In article <6p9vn3$nt$1@news.xmission.com>, max@mega.donetsk.ua (Max F. > Bilyk) wrote: > > > > > Hi all, > > > > we are running Informix OnLine 5.01 on SCO 3.2v4.2 > > > > and sometimes, when I am try to run this command > > --------------- 8< ---- cut here ---- 8< ---------- > > $ echo "drop database b_00014" | dbaccess - > > --------------- 8< ---- cut here ---- 8< ----------> > > > I receive this in answer > > > > --------------- 8< ---- cut here ---- 8< ---------- > > 214: Cannot remove file for table (syscolumns).> > > > 106: ISAM error: non-exclusive access. > > Error in line 1> > Near character position 21 > > --------------- 8< ---- cut here ---- 8< ---------- > > You can't get the required lock, check everybody is out of the system and > there are no rogue process Informix processes lying around. > > Paul Watson # I don't suffer from > WF Software Ltd. # stress, I'm just > Tel. (+44) 1436 674729 # a carrier > Fax. (+44) 1436 678693 # Use the command "onstat -g sql | grep b_00014" If you see any sessions running, then someone is in this database. So you have to remove that session.