Re: Dropping a dbspace

Calvin Shoults wrote: > > We are using IDS 7.31. There are a couple of dbspaces that we don't use and > do not reference. We would like to drop them, but an message tells us that > the spaces are not empty and will not let us drop them. > Any Solutions would be appreciated. Use oncheck -pe to see what is in those dbspaces, then delete or move them. > Also, what is the best path using the onstat commands to determine a > particular thread is causing a problem, not necessarly with locking but when > the system load takes off and you need to determine which thread is hurting > the system? Try onstat -g act -r 1 to see what is running. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+