Re: [ADSM-L] select statement to display readonly and filling tapes
2010-11-17 12:14:59
Thanks for this script
Regards
Tim
On 11/16/2010 6:49 AM, J. Pohlmann wrote:
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...
|
|
|