Impress your boss... !
use one of the following select statements to get a rough capacity of all
your tsm clients
(breakdown by node)
select node_name,sum(capacity) as "filespace capacity
MB",sum(capacity*pct_util/100) as "filespace occupied MB" from
adsm.filespaces where cast((current_timestamp-backup_end)day as
decimal(18,0))<2 and filespace_type not like 'API%' group by node_name
OR
(grand total)
select sum(capacity) as "filespace capacity MB",sum(capacity*pct_util/100)
as "filespace occupied MB" from adsm.filespaces where
cast((current_timestamp-backup_end)day as decimal(18,0))<2 and
filespace_type not like 'API%'
NOW do something like:
Nodes backed up by TSM servers...
Best I can tell from TSM internal info, have a total usable capacity of
64,038 GB of which 36,599 GB is currently occupied.
Now floppy disks hold 2 MB so that equates out to 32,787,456 floppy disks
worth of capacity of which 18,738,688 floppy disks are utilized/full.
Seeing how eight (8) floppy disks stack up to one (1) inch,
that capacity would be a stack of floppy disks 4,098,432 inches high, of
which a stack 2,342,336 inches in height is utilized/full.
Now, 12 in. = 1 ft
3 ft = 1 yd
1,760 yrds = 1 mile
so 63,360 inches = 1 mile
So the nodes backed up by the TSM servers have a capacity equal to a stack
of 2 MB floppy disks that is 64.68 miles high OF WHICH a stack of 2 MB
floppy disks that is 36.97 miles high is utilized/full.
NOTE: this assumes a floppy disk crush factor of zero (0)
and with a stack 64 miles high, the ones on the bottom are probably
(in reality) squished pretty thin...
|