Zhou Tianxiang Sent from HTC mobile!
----- Reply message ----- 发件人: "Paul_Dudley" <pdud...@anl.com.au> 日期: 周一, 7 月 18 日, 2011 年 12:00 下午 主题: [ADSM-L] SQL query - large files 收件人: <ADSM-L@VM.MARIST.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.