Re: Root DBS Contents

On 24/04/2008, Art S. Kagel (Oninit) <art@oninit.com> wrote: > CrispieCritter@gmail.com wrote: > > Hi All, > > > Critter: > > SELECT dbsname, tabname > FROM sysmaster:systabnames > WHERE dbinfo('dbspace',partnum) = 'rootdbs' > and dbsname not in ('sysmaster','sysadmin','sysutils','sysuser');> > Art S. Kagel > Oninit > > > I am currently running Informix 10 on a solaris box and someone here > > has done / created something that started filling up the root dbspace. > > I am the one who now needs to go investigate this and I am leaning > > toward the idea that someone has created a table or index incorrectly > > and it is now storing the data in the root dbspace. I think this is > > the case as this space as pretty much never increased in the 2+ years > > since the upgrade and now it is increasing daily. > > > > So my question is, is there an easy way to get a list of all the > > tables / index's that reside within a particular dbspace ? I just need > > to track down what non-system table is in this space so I can get > > someone to drop it and recreate it properly. > > > > Regards, > > > > Glenn > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list > > > > > > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > oncheck -pe will also show the contects of the root dbspace. Have yougot auto log adding configured and are your logs in the root dbspace? They could have 'aquired' the space. Keith