Matt,
The scratch column is case sensitive. Looks like the yes & no are
capitalized.
The status column is YES|NO|NULL
james
________________________________
From: ADSM: Dist Stor Manager on behalf of Richard Sims
Sent: Tue 11/30/2004 6:13 AM
To: [EMAIL PROTECTED]
Subject: Re: Select Statement Help for Volume Breakdown
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
