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: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
-- Met vriendelijke groeten/Kind regards, Remco Post
