Re: rootdbs eaten up

To quote INFORMIX-Online Admin. Guide Version 5.0, page 2-101: "Temporary tables created as part of internal processing or by using the SELECT ... INTO TEMP statement always reside in the root dbspace." This means a large rootdbs is still a good idea. In article <netnewsCxB3vJ.J7n@netcom.com>, wkidd@netcom.com (Wayne Kidd) wrote: > 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 > ________________________________________________