Hello David,
the following db2 command gives you the table names used by TSM :

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

the following db2 command gives you the index names used for the
BACKUP_OBJECTS table for example :

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


Rejean Larivee
IBM Tivoli Storage Manager Software Support




From:   David Ehresman <david.ehresman AT LOUISVILLE DOT EDU>
To:     ADSM-L AT VM.MARIST DOT EDU
Date:   09/25/2014 02:23 PM
Subject:        TSM Table Index
Sent by:        "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>



Is there a way to find out what indexes a given TSM table, e.g. the backups
table, has?  Just trying to optimize a select statement.

David