Re: Temp Table Space Gobbled Up

> > Darin Melin <melin@hermes1.sps.mot.com> wrote: > >You could also periodically run a 'tbcheck -pe > outfile.out' which will > >list all tables in each dbspace, ownerships, and sizing. > > No. Temp tables don't show up in a tbcheck -pe output. But you can watch the rootdbs space go away with a 'tbstat -d'. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, BSMC Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ "A thing is bigger for being shared" - Gaelic _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________