You could use the move nodedata to move other nodes off that tape or move
the node you want to keep to another tape.  
Say you have one node's data you want isolated... mark other filling vols in
that pool readonly and then just use a move nodedata.

If you want to purge just data on that tape for a single node...
Define a temp stgpool, then use the move nodedata with the tostgpool option,
send it to the temp pool, then del the vol with discard=yes.

Since the volumeusage has the copy type in it... you could add that into
your select statement.

     NODE_NAME: AAAAAAAAA
     COPY_TYPE: ARCHIVE
FILESPACE_NAME: /tdpmux
  STGPOOL_NAME: 3592P1A
   VOLUME_NAME: ABC123
  FILESPACE_ID: 2

select distinct node_name,volume_name from volumeusage where
copy_type='ARCHIVE' group by node_name,volume_name



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Lepre, James
Sent: Monday, June 01, 2009 4:04 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Question

 Hello Everyone,

 

 I have two questions

 

If I run the following select statement 

select distinct node_name from volumeusage where volume_name='xxxxxx'

 

I get a list of nodes on that tape.. Is there a way that I can delete
data from that tape by node 

 

For example I want to keep one node on that tape but delete the data
from the nodes

 

My second question is.. is there a select statement that can tell which
tapes have archive data on them by node

 

Thank you all

 

James 

 


  
  
---------------------------------------------------------------
Confidentiality Notice: The information in this e-mail and any attachments
thereto is intended for the named recipient(s) only.  This e-mail, including
any attachments, may contain information that is privileged and confidential
and subject to legal restrictions and penalties regarding its unauthorized
disclosure or other use.  If you are not the intended recipient, you are
hereby notified that any disclosure, copying, distribution, or the taking of
any action or inaction in reliance on the contents of this e-mail and any of
its attachments is STRICTLY PROHIBITED.  If you have received this e-mail in
error, please immediately notify the sender via return e-mail; delete this
e-mail and all attachments from your e-mail  system and your computer system
and network; and destroy any paper copies you may have in your possession.
Thank you for your cooperation.