Dbspaces and indexes

Hello, Is it possible to determine what dbspace an index resides in? I know generally the index resides in the same dbspace as the table, but there are exceptions. There dont seem to be any utilities to tell you where the index resides. I am sure there is a query from the SMI that would give me the answer. Can anyone help me out. TIA, Jonathan. -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

If you don't need to use SMI, you can do oncheck -ct database:table | grep indexname If you don't get a hit on the index name, then the index is in the same dbspace as the table. Otherwise it will tell you which dbspace the index is in. If you eliminate the grep, and instead pipe through more, you'll get detailed listings for each detached index, including number of pages used, etc. (Won't do this for attached indexes, though). jlsmith269@my-dejanews.com wrote in message <7deehg$ai9$1@nnrp1.dejanews.com>... >Hello, > >Is it possible to determine what dbspace an index resides in? I know >generally the index resides in the same dbspace as the table, but there are >exceptions. There dont seem to be any utilities to tell you where the index >resides. I am sure there is a query from the SMI that would give me the >answer. Can anyone help me out. > >TIA, > >Jonathan. > >-----------== Posted via Deja News, The Discussion Network ==---------- >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own