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