What I'm always wondering about when these sort of questions arise is
'why would you want to do _that_ ???'

I usually don't care about particular volumes unless they break, and I
don't care about nodes unless well, they either break or have
died ;-). Why do you only care about the data on that tape for that
volume? Has the node done something to you?

On 1 jun 2009, at 23:46, Dwight Cook wrote:

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

--

Met vriendelijke groeten/Kind regards,

Remco Post