Hopefully someone out there can help me. What I was trying to do was check to
see if my primary stg pool and copy storage pool contained the same
information. The way I was checking was using a select statement in the form:
select sum(physical_mb), sum(num_files) from occupancy where stgpool_name =
'ONSITE'
select sum(physical_mb), sum(num_files) from occupancy where stgpool_name =
'OFFSITE'
The number of files that come back are the same for both but the total size is
not the same. I can issue the backup stg pri copy preview=yes but it comes
back basically saying that the pools are the same. Just wondering why the
offsite pool has a larger total than the onsite. Could it be because of data
compression?? The reason I ask is that I have another smaller TSM server at
another location and when I run the script on it, both number come back the
same. Any comments would be appreciated.
Thanks
