They used to tell us that for the V5 DB. I think it went away with TSM V6. You would have to ask a DB2 person how to go into DB2 and look there.
And the problem there, a bunch of the tables are created on the fly, so I don't have a clue how you would find those. Anybody got a DB2 DBA in the house? W -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David Ehresman Sent: Thursday, September 25, 2014 1:23 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM Table Index 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