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 anyone have a select statement that shows this? I already have most of the statement below i just need to add "filling" to the statement select VOLUME_NAME,ACCESS from volumes where access ='READONLY' thanks for any help
