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.ehres...@louisville.edu> To: ADSM-L@VM.MARIST.EDU Date: 09/25/2014 02:23 PM Subject: TSM Table Index Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.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