I guess that's what I'm looking for today. A report that will show me where that particular file is on what particular tape for LNMBRZM355YR for the mail1 filesystem for the training.nsf database for the time frame of 7/08 - 1/09. It's just proof for them of where it resides as of today. I just don't know what the syntax of the SQL statement should be to get that information?
Any thoughts/ideas? Thanks! -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of George Huebschman Sent: Thursday, February 09, 2012 2:02 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Help! Select statement syntax for legal reasons I agree with Thom, the data gets spread everywhere and moved often by reclamation. You can only tell them where it was when you ran the report. On Thu, Feb 9, 2012 at 1:35 PM, Thomas Denier < thomas.den...@jeffersonhospital.org> wrote: > -----Joni Moyer wrote: ----- > > >I have a situation where someone wants to know what tapes particular > >people's backup data is on for our TDP for Mail backups for the time > >period from 7/08 - 1/09. The TSM client names are LNBRTZM3*5YR and > >the mail filesystem location is: mailx and the .nsf file names we are > >looking for are the training*.nsf and we need to know what tapes the > >data is on. > > > > > >LNBRTZM335YR, mail1\training.nsf > > > >LNBRTZM355YR, mail2\training2.nsf > > > >Does anyone know what the syntax of this select statement would be to > >find this information? Any help is greatly appreciated as I was told > >I need this information by EOD and I'm not quite sure how to gather > >this from the TSM server side. My TSM server is on AIX and is at > >5.5.5.0. > > TSM files on tape are more or less routinely moved to other volumes > by reclamation processing. As far as I can tell, there are three > possible ways of dealing with this possibility: suppress reclamation > of the volumes involved, send updates to the lawyers when and if > files are move to other volumes, or respond in bad faith by implying > that today's information will remain valid indefinitely. > > Thomas Denier ________________________________ This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark Inc., its subsidiaries, or affiliates.