Re: rootdbs eaten up

In <Cx7nAA.B78@cix.compulink.co.uk>, akent@cix.compulink.co.uk ("Andy Kent") writes: >Somehow, you are having sqlturbo processes aborting without getting the >chance to clean up temp table space. Are you killing them rather than >using tbmode -z? The space will remain allocated until the net time you >start up OnLine. As far as I know there is no other way to get rid of >them. (Short of dropping the database!) > >Temp tables do not explicitly show up in tbcheck output, but if you look >carefully you will notice some pages unaccounted for either by tables or >by free space. Those "holes" are temp tables. > >akent@cix.compulink.co.uk (Andy Kent) >------------------------------------- > You should set up online such that temp does not go to rootdbs if you want to keep it small. We establish a minimal rootdbs by redefining temp. Wayne ________________________________________________ G. Wayne Kidd TEAMOS2 ________________________________________________