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.