Not really.
The storage pool tapes are usually not 100% full.
As different files have different numbers of backup versions, some of those
tapes have less and less good data; their %reclaimable value goes up over
time.
So you can't count on all the tapes in the library being 100% full.
I usually count on the tapes being at best 65 - 70% full.
Here's a select command you can use to get a feel for the %utilization of
your tapes:
select stgpool_name, status,cast( mean(pct_utilized)as
decimal(5,2)) as avg_pctu from volumes -
where devclass_name <> 'DISK' group by stgpool_name, status
************************************************************************
Wanda Prather
The Johns Hopkins Applied Physics Lab
443-778-8769
[EMAIL PROTECTED]
"Intelligence has much less practical application than you'd think" -
Scott Adams/Dilbert
************************************************************************
> -----Original Message-----
> From: Selva, Perpetua [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, October 03, 2000 11:03 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Capacity and Storage Space on our Tape Library
>
> Hi All,
>
> Just wanted to confirm if this is what is actually happening within my
> Library as i'm planning on our capacity.
>
> Daily Data backups are around 15G
> Backup of Storage Pools doubles the amount to 30G
> Plus one tape for database backup ..
>
> By the end of the day... i have used up 7-10 tapes....
>
> Please verify if this is the proper procedures to follow..
>
>
> Thanks in advance
