Re: Urgent question about tables!

In article <6em0hg$56n$1@news.Eindhoven.NL.net>, "Nils van der Laan" <nilsl@simac.nl> wrote: >I have an urgent question about the location of tables. > >The application we use (BaanIV) was incorectly installed. The person who did >this, created a database called baanivc. He placed this database in de the >dbspace rootdbs and then extended is with chunks in other dbspaces. Now our >rootdbs (500Mb!) is full!. I would like to run a query that gives me the >following information: > >Which table from the database baanivc is stored in the dbspace rootdbs. > >Is this possible. If yes: how? > >Nils van der Laan >Nils.Laan@simac.nl > > I have found the easist way to identify what table is in which space, how fragmented the tables/spaces are, and pretty much anything about physical storage is to use oncockpit/onprobe. If you are using any recent release of OnLine, simply log on as user informix, start the data collector deamon by running onprobe, set your display variable (if necessary) and run oncockpit. Ray Garrison