Matt -
Do select * from volumes where scratch='Yes' That is, a volume which is in use in a storage pool, which came from the Scratch tape pool, will have its SCRATCH column set to Yes. A storage pool volume which is in the storage pool because of a Define Volume will have a SCRATCH column value of No.
Richard Sims
On Nov 30, 2004, at 7:21 AM, Matt Chan wrote:
Hello all,
Related to this in a way then, can anyone help me with how to determine which of all my defined tapes are scratch, for audit purposes ?
Matt Chan
"Stapleton, Mark" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 23/11/2004 07:23 AM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To [EMAIL PROTECTED] cc
Subject Re: Select Statement Help for Volume Breakdown
There are no scratch tapes in storage pools. A tape volume only exists in a storage pool when it contains client data (and is therefore no longer a scratch tape).
-- Mark Stapleton ([EMAIL PROTECTED]) Berbee Information Networks Office 262.521.5627
