Hi Arnaud,

you could do something like this: Sum up the occupany numbers for the
primary storagepool(s) and subtract the occupancy numbers of the copy
storagepool.

select sum(num_files), sum(physical_mb) from occupancy where
stgpool_name='primary storagepoolname' minus
select sum(num_files), sum(physical_mb) from occupancy where
stgpool_name='copy storagepoolname'

or if you have more primary storagepools you should replace
"stgpool_name='..'" with 
"stgpool_name IN 'list of primary storagepools'" or "stgpool_name LIKE
'name%'"

Hope this helps

Kind regards
Thomas Rupp
Vorarlberger Illwerke AG


-----Ursprüngliche Nachricht-----
Von: PAC Brion Arnaud [mailto:Arnaud.Brion AT PANALPINA DOT COM] 
Gesendet: Donnerstag, 23. Jänner 2003 14:55
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: Measuring progress of copy stgpool operation


Hi all,

Everything is in the title : is there a way (sql query ?) to find out,
during a copy stgpool process, how many objects, or even better how many MB
remains to be copied for finishing the process. Basically, the goal would be
having an idea of remaining duration till the job ceases
Thanks in advance !

Arnaud 

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
| Arnaud Brion, Panalpina Management Ltd., IT Group     |
| Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland |
| Phone: +41 61 226 19 78 / Fax: +41 61 226 17 01       | 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=