Hi

Doing some sizing for a client, who wants active data pools for a selection
of nodes

TSM Server v6.3.1

select sum(num_files) from occupancy:

Shows 139 million files. Fine

So i want to know how many active and inactive files from the backups
table, and the number of objects in the archives table (mainly as a matter
of interest)

Select count(*) from backups where state = 'ACTIVEVERSION'
38 million objects

Select count(*) from backups where state = 'INACTIVEVERSION'
41 million objects

Select count(*) from archives
4 million objects

So in total, 83 million objects

But 55 million less than the occupancy number of files

I thought it may be that a copy file might not appear in the backups or
archives table, but i have always assumed that it did. Happy to be told
otherwise, if definitely true.


Anyone have a thought on the discrepancy?

Regards