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 <[email protected]> To: [email protected] Date: 09/25/2014 02:23 PM Subject: TSM Table Index Sent by: "ADSM: Dist Stor Manager" <[email protected]> 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
