For scratches in our library this works:
SELECT LIBVOLUMES.VOLUME_NAME, LIBVOLUMES.STATUS
FROM LIBVOLUMES WHERE LIBVOLUMES.STATUS="Scratch"
>>> [EMAIL PROTECTED] 10/18/00 11:19AM >>>
That sounds like an excellent idea. At the moment we are running short on
tapes until we get a new batch in.
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
