>So, I was wondering:
>
>How do you folks deal with the desire to automatically answer the question
>
>"Are my copy pools up to date"
>
>?
>
>
I email the output from the following query run at the end of my backup stgpool 
cycle:

select node_name as "Node Name ",stgpool_name as "STGPool  ", -
cast(sum(num_files) as decimal(10,0)) as "Num Files", -
cast(sum(logical_mb) as decimal (15,2)) as "Log Occ (MB))" -
from occupancy  group by node_name,stgpool_name -
order by node_name,stgpool_name 

David