select count(volume_name) as "No.of Scratch Volumes" from libvolumes where
status='Scratch'

Regards

Raghu S Nivas
Consultant - TSM
DCM Data Systems Ltd
New Delhi
India.

e-mail: raghu AT cosmos.dcmds.co DOT in,dearaghu AT rediffmail DOT com.



                    Michelle Wiedeman
                    <michelle.wiedeman@MU        To:     ADSM-L AT VM.MARIST 
DOT EDU
                    LTRIX.COM>                   cc:
                    Sent by: "ADSM: Dist         Subject:     q libv
                    Stor Manager"
                    <ADSM-L AT VM.MARIST DOT EDU
                    >


                    10/07/2002 04:42 AM
                    Please respond to
                    "ADSM: Dist Stor
                    Manager"





hi!
does anyone know how to query the library volumes and see the amount of
scratch tapes there wthout having to plough through the whole list of all
volumes?

thnx,
Michelle