If you don't want to use DRM, here's another way: Change OFFSITETAPE to the name of your COPYPOOL.
select volume_name from volumes where stgpool_name='OFFSITETAPE' and volume_name in (select volume_name from libvolumes) Wanda Prather "I/O, I/O, It's all about I/O" -(me) -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ray Louvier Sent: Wednesday, September 07, 2005 6:57 PM To: ADSM-L@VM.MARIST.EDU Subject: Command to list Copy pool mountable tapes Does anyone have a select or query command to list copy pool tapes that are in the library only. Office: 281-871-5502 | Mobile: 713-471-1844 ---------------------------------------------------------------------- This e-mail, including any attached files, may contain confidential and privileged information for the sole use of the intended recipient. Any review, use, distribution, or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive information for the intended recipient), please contact the sender by reply e-mail and delete all copies of this message.
