Hi  Joe

Here a select command:

   select volume_name , stgpool_name , access  from volumes where
access='READONLY' or access='UNAVAILABLE'

Regards

Robert Ouzen
Computing Division
Haifa University
Israel



-----Original Message-----
From: Joerg Heiken [mailto:j.heiken AT BBDO-INTERACTIVE DOT DE]
Sent: Monday, October 14, 2002 11:03 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: select statement volume status


hi all,

i need a select statement, which output shows the status of the volumes like
unavailable, read only and so on.

thanx for help.

regards


joe

Joerg Heiken
Operator

BBDO Interactive GmbH
Gruenstr. 15
D-40212 Duesseldorf

phone: +49-211-93 08-403
fax:   +49-211-93 08-360
mailto:j.heiken AT bbdo-interactive DOT de

http://www.bbdo-interactive.de