This will count all the volumes by each storage pool.

select stgpool_name, count (*) as "# Vols." from volumes group by
stgpool_name

Gary L. Ison
101 Cold Harbor Drive
Frankfort, Ky.   40601
(502) 564-8724

> -----Original Message-----
> From: Larry Way
> Sent: Thursday, February 24, 2000 11:12 AM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: No of vlms
>
> Q stg (Pool Name) f=d ...will give you allocated tapes for pool
>
> Larry Way
> SL09/100D
> 408-743-4242  voice
> 408-743-4201  fax
>
> >>> jdohe1 AT ANFIS.CO DOT UK 02/24/00 03:46AM >>>
> Does anyone know how to get a count of the number of tapes in a storage
> pool.  IBM provide a good script that will tell you the %age of scratch
> tapes in any given pool.  If you query the volumes in a storage group.
> e.g.  'Q vol * stg=your storage pool name'
>
> This gives you the number of volumes used, but not the number of volumes
> allocated to the storage pool.  For example I have a co-located storage
> pool
> of 20 tapes (as defined in the GUI) but when I list the volumes in the
> pool
> I get the number 14 (only the volumes that are being used)  If I run the
> 'Q_scratch_stg' then this tells me that I have used 70% of the pool. ie.
> 14/20 as % = 70  If I did not have access to the GUI how would I know the
> number of volumes in a particular storage pool.
>
> Thanks in advance
>
> > John Doherty. Tel:   +44   (0)   141 275 7793
> >               Fax:  +44   (0)   141 275 9199
> >               Email: JDohe1 AT Anfis.co DOT uk
> >
> >       Technical Specialist, Storage Management L02S
> >
> > Email communications are not necessarily secure and may be intercepted
> or
> > changed after they are sent.  Abbey National Financial and Investment
> > Services  does not accept liability for any such changes. If you wish to
> > confirm the origin or content of this communication, please contact the
> > sender using an alternative means of communication.  This communication
> > does not create or modify any contract.  If you are not the intended
> > recipient of this communication you should destroy it without copying,
> > disclosing or otherwise using its contents.  Please notify the sender
> > immediately of the error.
> >
> > ABBEY NATIONAL FINANCIAL AND INVESTMENT SERVICES plc
> >         Registered Office Abbey National House 287 St Vincent Street
> >         Glasgow G2 5NB United Kingdom Registered in Scotland No 159852
> >