Hi I'm using that select command (cut and paste those 3 lines into TSM console)
select stgpool_name as "Storage Pool",sum(num_files) as "Number of Files", - sum(physical_mb)/1024 as "Total Physical GBs" - from occupancy group by stgpool_name Luc Beaudoin Administrateur Réseau / Network Administrator Hopital General Juif S.M.B.D. Tel: (514) 340-8222 ext:8254 Richard Sims <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[email protected]> 2006-01-10 02:07 PM Please respond to "ADSM: Dist Stor Manager" To: [email protected] cc: Subject: Re: Best way to compare the pools ? On Jan 10, 2006, at 1:29 PM, Vats.Ashok wrote: > We have primary pool and offsite pool. We run backup from primary > to offsite pool everyday using cron. I was wondering what is the > best practice to copy primary to offsite pool ? Also how do I > compare the two pools to see if offsite is caught up with primary. > Typically I use q * * stg=primarypool & q * * stg=offsitepool but > it takes a long time to run these commands & compare the output. If the primary pool is backed up only to that offsite copy storage pool (and not also an on-site copy storage pool), you can do 'select * from auditocc', which is nearly instantaneous. Richard Sims http://people.bu.edu/rbs
