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:


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


select dbinfo('dbspace', partnum) from systables