Determine which tables and indexes are in which dbspaces
All 2 messages in topic - view as tree
From: Kennedy, Randy - view profile
Date: Thurs, Dec 7 2006 8:30 pm
Email: "Kennedy, Randy"


I am trying to run a SQL against system tables that will show me which
tables are in each dbspace and then correlate their indexes to see if
the indexes are in the same dbspace. I know have some indexes in
dbspaces that have tables in other dbspaces and want a query that will
show me all of them at once to determine if they are where they should
be or I need to move them.


sysfragments shows me a indexname and dbspace, but I can't seem to see
where the dbspace for the tables are listed (I can't find it in
systables).


Thanks,
Randy


Reply » Rate this post: Text for clearing space


From: SaltTan - view profile
Date: Fri, Dec 8 2006 2:09 pm
Email: "SaltTan"


select dbinfo('dbspace', partnum) from systables


- Hide quoted text -
- Show quoted text -

> I am trying to run a SQL against system tables that will show me which
> tables are in each dbspace and then correlate their indexes to see if
> the indexes are in the same dbspace. I know have some indexes in
> dbspaces that have tables in other dbspaces and want a query that will
> show me all of them at once to determine if they are where they should
> be or I need to move them.

> sysfragments shows me a indexname and dbspace, but I can't seem to see
> where the dbspace for the tables are listed (I can't find it in
> systables).


> Thanks,
> Randy


I am trying to run
> a SQL against system tables that will show me which tables are in each dbspace
> and then correlate their indexes to see if the indexes are in the same
> dbspace.  I know have some indexes in dbspaces that have tables in other
> dbspaces and want a query that will show me all of them at once to determine if
> they are where they should be or I need to move them. sysfragments shows
> me a indexname and dbspace, but I can't seem to see where the dbspace for the
> tables are listed (I can't find it in systables).
> ------_=_NextPart_001_01C71A2D.D469C480--



Reply » Rate this post: Text for clearing space


End of messages