How to check which tablespace an index is in?

john_wsm · #1 (**permalink**) 03-30-04, 21:16

Hi all,

pls help on the captioned, thanks!

ME

Marcus_A · #2 (**permalink**) 03-30-04, 22:18

In the catalog view syscat.tables there is a column called index_tbspace that should provide what you need. If it is null, the indexes for the table are in the same tablespace as the data (tbspace).

In version 8, the syscat.indexes view has added a column called TBSPACEID which maps to the tablespace name in syscat.tablespaces.

damru · #3 (**permalink**) 03-31-04, 16:13

If you are using DB2 in os/390 or z/os you can use following query
SELECT TSNAME FROM SYSIBM.SYSTABLES WHERE NAME IN (SELECT TBNAME
FROM SYSIBM.SYSINDEXES WHERE NAME=' index name')

Internet Services

Web Development

Digital Marketing

Consumer Tech