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:ads...@vm.marist.edu] On Behalf Of Lepre, James Sent: Monday, June 01, 2009 4:04 PM To: ADSM-L@VM.MARIST.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.