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