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:[email protected]] On Behalf Of Guido Martínez Sent: Monday, November 15, 2010 09:35 To: [email protected] 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" <[email protected]> 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 [email protected] From: Timothy Hughes <[email protected]> To: [email protected] Date: 11/15/2010 07:40 AM Subject: select statement to display readonly and filling tapes Sent by: "ADSM: Dist Stor Manager" <[email protected]> Hi I am trying to add "filling" tapes to this select statement and I am having no luck does anyo...
