Hello David,
I use,
select count(*) from libvolumes where status='Scratch'
Matthew.
>Do you know of an _easy_ way to tell just how many scratch
>tapes we have?
>
>We are using select statements using the info in the volumes table. The
>problem is the tapes only show in stgpool_name as either copypool or
>tapepool. I run a select statement to get the number of
>copypool tapes then
>another to get the number of tapepool tapes. Then I have to add then
>together and subtract that from the number of tapes we put in
>the library to
>begin with.
>
>It's a convoluted process but that's the best I can come up
>right now. I
>can't find a direct way to tell me the number of scratch tapes I have.
>
>-----Original Message-----
>From: Richard Sims [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, October 18, 2000 10:44 AM
>To: [EMAIL PROTECTED]
>Subject: Re: Several tapes with zero capacity and zero utilization
>
>
>>When I get several tapes with a PCT_RECLAIM above 70-80%
>>I run the reclamation process.
>
>David - Another approach to scratch pool management is to wait until
> the number of scratches reaches a comfortable minimum, and
>only then start reclamation. I prefer to let attrition empty tapes
>as much as possible, rather than subject tapes to wear in copying
>remaining contents sooner than necessary - considering also that
>that remainder may expire soon anyway, making that much copying
>wasteful.
>
>>How can I have a tapes with 0 capacity and 0 utilization?
>
>What your display doesn't tell you is the state of the tapes.
>Particularly for a copy storage pool, REUsedelay should be in effect,
>and the volumes would thus be Pending.
>
> Richard Sims, BU
>
