I am not sure if this is exactly what you are looking for but this select statement gives you the number of files and the amount of data in each pool. Then you can compare the totals of your primary pools vs. your copy pools.
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 Here is a sample output from my test server. Storage Pool Number of Files Total Physical GBs ------------------ --------------- --------------------------------- ARCHMP 1060382 76.13 ARCHMPCP 1060382 76.13 BKUPMP 947657 31.93 BKUPMPCP 947667 48.64 GHOSTMP 10 16.97 You can see that the ARCHMP and ARCHMPCP pools are in sync all data in the ARCHMP primary pool is backed up to the ARCHMPCP copy pool. Also, you will note that the primary pools of BKUPMP and GHOSTMP are backed up to the copy pool BKUPMPCP and they add up as well. Therefore, on my test server all data in primary pools is backed up to my copy pools. I hope this helps. -- Regards, Mark D. Rodriguez President MDR Consulting, Inc. =============================================================================== MDR Consulting The very best in Technical Training and Consulting. IBM Advanced Business Partner SAIR Linux and GNU Authorized Center for Education IBM Certified Advanced Technical Expert, CATE AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux Red Hat Certified Engineer, RHCE =============================================================================== Luc Beaudoin wrote:
Hi all I would like to make sure that the occupency in my library and what's offsite are the same but I dont remember the command .... can someone help me on that one Thanks Luc