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" <mark.stapleton AT BERBEE DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
23/11/2004 07:23 AM
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
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 (stapleton AT berbee DOT com)
Berbee Information Networks
Office 262.521.5627