Please be aware that ADSM.ORG will be going through forum software conversion and migration over the next several weeks. The cut-over date and time will be posted in the ADSM.ORG News & Announcements section as we near the target date. Please visit the following link for more details ADSM News & Announcements
Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.
There is no easy method to reconcile primary tapes with offsite tapes. The way to reconcile is compare the number of copied files in the primary and copy pools.
Code:
select volumes.stgpool_name,contents.copied,count(contents.volume_name) from volumes,contents where volumes.volume_name=contents.volume_name group by volumes.stgpool_name,contents.copied
You are going to have to know which primary goes to which copy to do the comparison.