ADSM-L

Fun with numbers...(tsm client capacities)

2002-05-31 12:26:34
Subject: Fun with numbers...(tsm client capacities)
From: "Cook, Dwight E" <DWIGHT.E.COOK AT SAIC DOT COM>
Date: Fri, 31 May 2002 09:23:00 -0700
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...
<Prev in Thread] Current Thread [Next in Thread>
  • Fun with numbers...(tsm client capacities), Cook, Dwight E <=