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
> internal tables, but I haven't quite that ambitious yet.
It is version 5.5
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.