No, BACKUPS and ARCHIVES have just one entry per file, regardless of the
number of storage pools it's in. NUM_FILES from OCCUPANCY counts the
number of files per storage pool, so it includes primary/active/copy pools.
You can look at the system catalog to see the schema of those tables:
SELECT CO
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 t