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:[EMAIL PROTECTED]] Gesendet: Donnerstag, 23. Jänner 2003 14:55 An: [EMAIL PROTECTED] 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 | =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
