Re: Select statememt for DRM

Try something like 'select count(*) storage volumes where
wherestate=mountable' or something like that.



--
Joshua S. Bassi
IBM Certified - AIX 4/5L, SAN, Shark
eServer Systems Expert -pSeries HACMP
Tivoli Certified Consultant - ADSM/TSM
Cell (415) 215-0326
jbassi AT ihwy DOT com

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Jin Bae Chi
Sent: Thursday, August 01, 2002 5:11 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Select statememt for DRM

Hi, TSM experts,

I try to start to use DRM and when I do 'q drm * wherestate=mountable',
it shows all the volumes and their status, but not the totoal number of
volumes. Does anyone know the correct select statement for showing the
count wiht volume numbers? So, the operator and courier will be sure of
numbers to move in and out. Thanks again for your help.






Jin Bae Chi (Gus)
Data Center
614-287-2496
614-287-5488 Fax
e-mail: jbaechi AT cscc DOT edu