Tivoli Storage Manager Server database table indexes

Problem(Abstract)
This document provides information on how to obtain the list of indexes that the Tivoli Storage Manager server uses.

Resolving the problem
You can get the list of table indexes that are used by the Tivoli Storage Manager server by using a select command from the syscat.indexes table.

First, you must connect to the DB2 instance for the Tivoli Storage Manager server.

In a Windows environment, complete the following steps :

Open a Windows command prompt.
Run the db2cmd command. This opens a new command window with the DB2 environment set up.

From this new window, run the following commands :

set DB2INSTANCE=server1
db2 connect to TSMDB1
db2 set schema TSMDB1

In a UNIX or Linux environment, complete the following steps :

Log on with the instance user ID.
From a shell, run the following commands :

db2 connect to TSMDB1
db2 set schema TSMDB1
After you connect to the database, you can run DB2 select commands.

To get the list of all table indexes that are used by the Tivoli Storage Manager server, run the following command :

db2 "select indname from syscat.indexes where indschema='TSMDB1'"

To get a list of indexes that are used by a specific table, use the tabname parameter to identify the table name. For example, to get a list of indexes that used by the BACKUP_OBJECTS table, run the following command :
db2 "select indname from syscat.indexes where indschema='TSMDB1' and tabname='BACKUP_OBJECTS'"

To get a list of table names, run the following command :

db2 "select tabname from syscat.tables where tabschema='TSMDB1' and type='V'