That's a great beginning to figuring out how many tapes you will need. If your
backup/archive schedules have not changed for a month... suggest doing:
q actl begindate=-30 search=ANR1214
Take the amount of data copied from your primary tapepool to copy tapepool for
each day and add it up and divide by
30 for both backups and archives. Then divide this amount of data by the average
for all storage pools as computed by
Wanda's SQL... this should be as accurate as any way of determining the amount
of tapes required and then you should
plus this amount up by suspected or anticipated growth. You could do this on a
yearly basis to determine what the average
growth rate of what is being backed up is and intelligently guess how many tapes
to purchase (or how long it will take the
developers to finish a software project ;-) George





"Prather, Wanda" <Wanda.Prather AT JHUAPL DOT EDU> on 02/16/2001 02:01:11 PM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

To:   ADSM-L AT VM.MARIST DOT EDU
cc:    (bcc: George Lesho/Partners/AFC)
Fax to:
Subject:  Re: Formula to calculate # tapes required



I agree.  Here is a query that will do it for you:

select stgpool_name as stgpool,
cast(mean(est_capacity_MB/1024) as decimal(5,2)) as
gb_per_FULL_vol from volumes where status='FULL' group by
stgpool_name