Zhou Tianxiang
Sent from HTC mobile!

----- Reply message -----
发件人： "Paul_Dudley" <pdudley AT ANL.COM DOT AU>
日期： 周一, 7 月 18 日, 2011 年 12:00 下午
主题： [ADSM-L] SQL query - large files
收件人： <ADSM-L AT VM.MARIST DOT EDU>

> -----Original Message-----
>
> 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

It is version 5.5

Regards
Paul






ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named addressees. Any unauthorised dissemination or use is strictly prohibited. 
If you received this e-mail in error, please immediately notify the sender by 
return e-mail from your system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.