Re: check on allowed scratch tapes!

One of our Servergraph monitors does, essentially, this: dsmadmc ... q libvol | grep Scratch | wc -l to spit out how many scratch tapes are in use. - Mr. Lindsay Morris Lead Architect, Servergraph www.servergraph.com 859-253-8000

Re: check on allowed scratch tapes!

select stgpool_name,count(*) from volumes group by stgpool_name

Re: check on allowed scratch tapes!

SELECT [STGPOOL_NAME], [MAXSCRATCH] FROM STGPOOLS; >>> [EMAIL PROTECTED] 11/08/02 09:24AM >>> At 22:23 -0800 11/7/02, Chetan H. Ravnikar wrote: >What I am looking for is, the value which is set in a storage pool > *Max allowed scratch tapes*. >Any select statement statement which gives that

Re: check on allowed scratch tapes!

At 22:23 -0800 11/7/02, Chetan H. Ravnikar wrote: What I am looking for is, the value which is set in a storage pool *Max allowed scratch tapes*. Any select statement statement which gives that value!? I can script something.. quickly Try select stgpool_name,maxscratch,pct_utilized from st