Re: q libv

[Raghu S]

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: [EMAIL PROTECTED],[EMAIL PROTECTED]



                    Michelle Wiedeman
                    <michelle.wiedeman@MU        To:     [EMAIL PROTECTED]
                    LTRIX.COM>                   cc:
                    Sent by: "ADSM: Dist         Subject:     q libv
                    Stor Manager"
                    <[EMAIL PROTECTED]
                    >


                    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