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 AT VM.MARIST DOT EDU] On Behalf Of
George Huebschman
Sent: Thursday, February 09, 2012 2:02 PM
To: ADSM-L AT VM.MARIST DOT 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.Denier AT jeffersonhospital DOT 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.
|
