Re: No of vlms
2000-02-24 11:28:02
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
> >
|
|
|