Backup space

[janisaltmanis]

Hi! How can I check as a whole how large all backup is in TSM?

 

[moon-buddy]

This select command shows how much data in total by storage pool and type - backup or archive:

SELECT stgpool_name, type, CAST(FLOAT(SUM(logical_mb))/1024 AS DEC(8,2)) as GB, SUM(num_files) as Number_of_files FROM occupancy GROUP BY stgpool_name, type ORDER BY stgpool_name, type