Mark, Thanks, Can this select statement be altered to just show what is not in Sync between the primary and copypools?
Thanks "Mark D. Rodriguez" wrote: > Timothy, > > I use the following select statement. It list the number files and GB's > of data for each storage pool. If the numbers add up I assume all is > well. I realize this might not be 100% true but any scenario were this > would not be true seem so remote that I don't worry about it. > > 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 > > -- > 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 > =============================================================================== > > Timothy Hughes wrote: > > >Hello, > > > >I run a Backup STGPOOL DISKPOOL to CopyPool, Backup STGPOOL TAPEPOOL > >COPYPOOL every morning as a Admin Schedule. Is there any way to > >check to make sure Primary and CopyPools are in sync after these > >processes are completed? > > > > > >Thanks in Advance! > > > >TSM 5.3.1.4 > >RS/6000 AIX 5.2 > > > > > >
