Troubleshooting
Problem
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
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'
[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Supported Versions","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21685457