Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Kennedy, Randy — — source: Usenet: comp.databases.informix
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
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.