Re: Select Statement Help for Volume Breakdown
2004-11-22 15:23:46
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.
>
|
|
|