For what it's worth, here is my "reado" script to display problem tapes:

issue message i "Read Only Volumes"
q vol acc=reado
issue message i "Unavailable Volumes"
q vol acc=unav
issue message i "Destroyed Volumes"
q vol acc=destroyed
issue message i "The following volumes had I/O errors:"
select volume_name as "VOLUME                   ", stgpool_name,
write_errors, read_errors from volumes where write_errors >0 or read_errors
>0

Joerg Pohlmann
250-585-3711



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Guido Martínez
Sent: Monday, November 15, 2010 09:35
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] select statement to display readonly and filling tapes

Perhaps this would also work:

Select VOLUME_NAME from VOLUMES where status='FILLING' and access='READONLY'

El nov 15, 2010 11:30 a.m., "Keith M Williams" <kwilliam AT us.ibm DOT com>
escribió:

How about  this for TSM:

select VOLUME_NAME,ACCESS from volumes where access ='READONLY', STATUS from
media where VOLUME_NAME='FILLING'

Keith M Williams/Dubuque/IBM
Unix System Administrator, IBM Dubuque
ITDelivery, Global Technology Services
kwilliam AT us.ibm DOT com




From:

Timothy Hughes <Timothy.Hughes AT OIT.STATE.NJ DOT US>
To:
ADSM-L AT vm.marist DOT edu
Date:
11/15/2010 07:40 AM
Subject:

select statement to display readonly and filling tapes Sent by:
"ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>




Hi

I am trying to add "filling" tapes to this select statement and I am having
no luck does anyo...