The "Backup stg" command depends on pointers that are suppose to inidcate the last backed up data so that it spends less time scanning what to backup. There have been apars where that process gets broken and not all the primary storagepool data gets backed up to copypool. The Select would spot such a condition but the "backup stg preview" would not.
David >>> [EMAIL PROTECTED] 11/02/05 7:37 AM >>> 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
