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.