Here's an example that you can use as a model...you may want to strip out
the having stgpool_name like '%TAPE%' clause and the output redirection...
you may have to tailor to exclude disk....volumes...to your shop...

set sqldisplaymode wide
select current date as tmpdt, count(*) volume_name, stgpool_name from volumes -
group by stgpool_name having stgpool_name like '%TAPE%' > /tmp/tapeutil_by_stgpo
ol

example output:
1999-10-29             155     BKUPTAPE
1999-10-29             184     BKUPTAPE_CP
1999-10-29              28     EXCHTAPE
1999-10-29              33     EXCHTAPE_CP
1999-10-29              44     INTLTAPE
1999-10-29              45     INTLTAPE_CP
1999-10-29             298     NOTETAPE
1999-10-29             294     NOTETAPE_CP
1999-10-29             260     ORCLTAPE
1999-10-29             286     ORCLTAPE_CP






Greg Dick <gregoryd AT ISC.UPENN DOT EDU>
05/09/2000 08:28 AM

To:   ADSM-L AT VM.MARIST DOT EDU@SMTP@Exchange
cc:
Subject:  Command for finding...

Anybody know what command I can use to find out how many tapes are in a
storage pool?
ThanX,
Greg