Howto check if all data in primary pool is copied to copypool

[dojabergen]

Hi,
I have a script running daily which copies primary pool data to copypool.
I am wondering if there is a cmd or a 'select statement' to check of all data in a specific primary pool has the copied / is in sync with the copypool?

Thank you in advance!

 

[marclant]

If you run backup stgpool a 2nd time and it has nothing to copy, you know it has copied everything. Now, if there was new data backed up between your 1st and 2nd backup stgpool, then that would get picked up.

You could also use this to check the CONTENTS table to count how many objects are copied and not copied by primary storage pool.

select v.stgpool_name,c.copied,count(c.copied) as "Number of objects" -
from contents c, volumes v where v.stgpool_name in (select stgpool_name -
from stgpools where pooltype='PRIMARY') group by v.stgpool_name,c.copied

 

[dojabergen]

Hi,
thank you for your answer! Yes, this works. It gives an overview of all the primary pools. I ran it on a test tsmserver and it works ok. But when running it on our production tsmserver, it 'never ends'. I think it is a resource intensive script.
Is it possible just to select ONE primary pool and then see the result?
Thanks in advance!