I tried using the Q content (volumename) copied=no
and it does take way to long.  I am better off using the
TSM ODBC and viewing from the spreadsheet.

Thanks again!

"Thorneycroft, Doug" wrote:

> Look at IC45931 it tells you how to identify and correct differences between
> your primary and copy storage pools.
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Dirk Kastens
> Sent: Wednesday, November 02, 2005 4:37 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Checking to make sure TSM Primary and Copypools are in Sync
>
> Hi,
>
> Mark D. Rodriguez schrieb:
>
> > 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
>
> Wouldn't a "BACKUP STGPOOL <primary pool> <copypool> PREVIEW=Y"
> be sufficient to get the number of files and the amount of data?
> Or does it take too long? If the result is not null you know that the
> pools are not in sync.
>
> --
> Regards,
>
> Dirk Kastens
> Universitaet Osnabrueck, Rechenzentrum (Computer Center)
> Albrechtstr. 28, 49069 Osnabrueck, Germany
> Tel.: +49-541-969-2347, FAX: -2470