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 kwill...@us.ibm.com From: Timothy Hughes <timothy.hug...@oit.state.nj.us> To: ADSM-L@vm.marist.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@vm.marist.edu> 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
