On Jul 17, 2011, at 9:07 PM, Paul_Dudley wrote:

> Is it possible to interrogate the TSM database with an SQL query to display 
> the list of backed up files whose size is larger than - for example - 160 Mbs?
> 
> I understand that this will be a query that will take a while to run so I am 
> prepared to run it on the weekend. While the total number of files is large 
> the number of files larger than 160 Mb is quite small.

V5 or V6? 

With version 5, the CONTENTS table and the BACKUPS tables are both indexed 
reasonably well. BACKUPS has the size and might be all you need. 

Version 6? The BACKUPS view (table?) doesn't have enough indices on it to be 
useful. A colleague at work is trying to dare me to use DB2 to look at the real 
internal tables, but I haven't quite that ambitious yet.

Nick