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 AT VM.MARIST DOT EDU] On Behalf Of 
David Ehresman
Sent: Thursday, September 25, 2014 1:23 PM
To: ADSM-L AT VM.MARIST DOT 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