> 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).
Just a footnote on this: Though less commonly seen, an empty tape volume can also exist in a storage pool if it is manually defined to that pool by the administrator (but even then, it is not the same as a scratch tape). Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> wrote on 11/22/2004 13:23:37: > 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. > >
