Hi. A file can be stored on one volume in the primary pool and span two volumes in a copy pool, or vice versa. You might obtain better results by summing occupancy data by stgpool.
On 8/11/2012 2:54 AM, Mehdi Salehi wrote:
Hi, There are two LTO pools in this TSM server, one "primary" and the other "copy". I cannot explain why the two stg pools have different number of records in CONTENTS table: primary pool: POOL1 copy pool: POOL2 - All disk-based stg pools and volumes are empty. They have been migrated to POOL1 - no node is connected to the server. - "backup stg POOL1 POOL2" finds nothing to copy. - There is no damaged file in the contents: "select count(*) from contents where damaged!='No'" - Here is the difference: query_result1: select count(*) from contents where volume_name in (select volume_name from volumes where stgpool_name='POOL1) query_result2: select count(*) from contents where volume_name in (select volume_name from volumes where stgpool_name='POOL2) query_result12 = query_result1 + 12 !!! Thank you in advance.
