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 ([EMAIL PROTECTED]) Berbee Information Networks Office 262.521.5627 >-----Original Message----- >From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On >Behalf Of Nancy L Backhaus >Sent: Monday, November 22, 2004 12:59 PM >To: [EMAIL PROTECTED] >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 >[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. >
