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 <rbs AT BU DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
2006-01-10 02:07 PM
Please respond to "ADSM: Dist Stor Manager"

 
        To:     ADSM-L AT VM.MARIST DOT EDU
        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