Re: Temp Table Space Gobbled Up

> > No. Temp tables don't show up in a tbcheck -pe output. > > > June > > That's what I observed. I ultimately had to do a restart to recover > all of the space in rootdbs. .... .... > > So is there any improvement in 7.1 that enables me to track down owners > of temp table space so I can get rid of them? 6.0 DSA has numerous enhancements to the tbstat (now onstat) utility. A feature called onstat -g sql shows you the TTs owned by a specific user process (or rather thread). Another advantage is that, because DSA does its own scheduling, there are no sqlturbos and therefore no chance of anyone using kill on them, so the risk of it happening in the first place is reduced. > Upon recovery Informix dropped 163 > temp table tbspaces ranging in size from 8 to 8205 pages. Also, even > with Informix completely offline, I still had 20+ sqlturbos lying > around which I had to blow off with kill -9. I presume these two > factors are related. Sounds like the sqlturbos could have been zapped with tbmode -z before bringing OnLine down? Although it's odd that running Shutdown didn't do this for you. (I assume you ran shutdown and not kill?) akent@cix.compulink.co.uk (Andy Kent) ------------------------------------------------ Freelance Informix Database Specialist, Redland, Bristol, England