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 [EMAIL PROTECTED] -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Jin Bae Chi Sent: Thursday, August 01, 2002 5:11 PM To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
