Shekhar,

"select count(*) from volumes ..."

counts the volumes already attached to storagepools
not the tapes in the tape library

if you have 400 tapes in the STK - Library named 'STK-LIB' try a
"select count(*) from libvolumes where LIBRARY_NAME='STK-LIB'"

and yu will get

Unnamed[1]
-----------
        400
        400

regards

Peter Sternecker
ZI-SB-ST-BS
R+V Versicherungs AG
John-F.-Kennedy-Str.1
D-65189 Wiesbaden                       EMail: Peter.Sternecker AT ruv DOT de



> -----Original Message-----
> From: Shekhar Dhotre [mailto:Shekhar.Dhotre.B AT BAYER DOT COM]
> Sent: Wednesday, September 20, 2000 3:19 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Determining Capacity on ADSM?
>
>
> Yes   you won the bet , but i am having 400tapes in STK,and
> the query shows 47?
>
>                        ^^^
>
> tsm: TSM>select count(*) from volumes where devclass_name='STK9710'
>
>  Unnamed[1]
> -----------
>          47
>