> 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).

Just a footnote on this: Though less commonly seen, an empty tape volume
can also exist in a storage pool if it is manually defined to that pool by
the administrator (but even then, it is not the same as a scratch tape).

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 11/22/2004
13:23:37:

> 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
>
> >-----Original Message-----
> >From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On
> >Behalf Of Nancy L Backhaus
> >Sent: Monday, November 22, 2004 12:59 PM
> >To: ADSM-L AT VM.MARIST DOT EDU
> >Subject: Select Statement Help for Volume Breakdown
> >
> >How do I combine these two scripts?   I want to be able to see
> >a breakdown
> >by stg pools  & breakdown of  scratch/privates in the stgpools.
> >
> >select status, count(*) from libvolumes where library_name = 'LTOLIB'
> >group by status
> >
> >I have this..but, I really want to see the scratch/private breakdown?
> >
> >select stgpool_name, status, scratch, count(*) as "Volumes" -
> >from volumes - group by status, scratch, stgpool_name
> >
> >
> >STGPOOL_NAME           STATUS                 SCRATCH Volumes
> >------------------     ------------------     ------------------
> >-----------
> >APIDR1                 EMPTY                  YES     2
> >BCBSDR2                EMPTY                  YES     1
> >APIDR1                 FILLING                YES    13
> >APIDR2                 FILLING                YES    12
> >
> >
> >
> >
> >Background:
> >
> >Operating Sys - AIX 5.2.2.0
> >TSM- 5.2.3.3
> >
> >
> >
> >Nancy Backhaus
> >Enterprise Systems
> >Backhaus.Nancy AT HealthNow DOT org
> >Office: (716) 887-7979
> >Cell: (716)  609-2138
> >
> >CONFIDENTIALITY NOTICE: This email message and any attachments
> >are for the sole use of the intended recipient(s) and may
> >contain proprietary, confidential, trade secret or privileged
> >information.  Any unauthorized review, use, disclosure or
> >distribution is prohibited and may be a violation of law.  If
> >you are not the intended recipient or a person responsible for
> >delivering this message to an intended recipient, please
> >contact the sender by reply email and destroy all copies of
> >the original message.
> >