Re: Urgent question about tables!

SaTriGuy wrote: > > >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? > > Run oncheck -pe Also you can: SELECT tabname, hex(partnum) from systables where tabid > 99; And look for partnums that start with 0x001 for a version 6 or 7.xx server or 0x01 for a version 5.xx server. BTW in 7.xx the fastest way to move the table seems to be the ALTER FRAGMENT .... INIT IN <dbspace> command. Art S. Kagel