Re: Urgent question about tables!

Nils van der Laan 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 If you're using Informix 7.x: select prof.tabname from sysdbspaces dbs, sysptprof prof where dbs.dbsnum = trunc(hex(prof.partnum)/1048576) and prof.dbsname = 'baanivc' and dbs.name = 'rootdbs' Hope this helps! John Carlson Informix DBA WH Smith, Inc.