The reason for this is because we have one of our important nodes going to physical tape and the rest going to a VTL. A few weeks ago we had a problem with our VTL and had to make all of our node go to physical tape. Not everything expires off of the tapes and I want to clean them up so that the only thing on the tapes is that important node
James Lepre Senior Server Specialist Solix Inc 100 South Jefferson Road Whippany NJ 07981 Work Phone: 1-973-581-5362 Cell Phone: 1-972-223-1921 -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Remco Post Sent: Monday, June 01, 2009 7:22 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Question 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 --------------------------------------------------------------- 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.
