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

+> In article <6p9vn3$nt$1@news.xmission.com>, max@mega.donetsk.ua (Max F. +> Bilyk) wrote: +> > we are running Informix OnLine 5.01 on SCO 3.2v4.2 <snip> Tim Jones <tojones@gate.net> offerred: +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. Onstat -g was not available in version 5.X. In fact, there is no "onstat" in 5.X (drives me crazy to work on this version), it is "tbstat". Nor were there any sessions that could be removed (in 5.0 they were "users"). They could run tbstat -a | grep b_00014 to see if there is anything with that address. Onstat -k should show if there are any locks left around. Best bet would be to shut the server down, then retry the drop database after bringing it back up. Dave ** Dave Kosenko <davek@summitdata.com> ** Director of Training Services (732) 469-4070 ** Summit Data Group (an Informix Authorized Education Center) ** Find my advice useful? Let me teach you everything I know about ** Informix. Sign up for OFFICIAL Informix training at SDG. ** For details, see http://www.summitdata.com/training