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:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 11:03 AM To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED] http://www.bbdo-interactive.de
