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
