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
regards
Peter Sternecker
ZI-SB-ST-BS
R+V Versicherungs AG
John-F.-Kennedy-Str.1
D-65189 Wiesbaden EMail: [EMAIL PROTECTED]
> -----Original Message-----
> From: Shekhar Dhotre [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 20, 2000 3:19 PM
> To: [EMAIL PROTECTED]
> 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
>
