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 [EMAIL PROTECTED] 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.
