When formulating your queries, please keep this in mind...
>From the Data Protect for Domino User's Guide...
A single database backup is stored as two objects on the
Tivoli Storage Manager server. The objects created are the
relative database name and the relative database name
plus a .DATA extension. For example, a backup of
database mail6\user1.nsf would result in the following two objects:
1. The relative name of the database:
mail6\user1.nsf
2. The relative name of the database plus .DATA:
mail6\user1.nsf.DATA
Thanks,
Del
----------------------------------------------------
Del Hoobler
Tivoli Storage Manager Development
IBM Corporation
"ADSM: Dist Stor Manager" <ADSM-L@vm.marist.edu> wrote on 02/09/2012
03:44:49 PM:
> From: Xav Paice <xpa...@oss.co.nz>
> To: ADSM-L@vm.marist.edu
> Date: 02/09/2012 03:48 PM
> Subject: Re: Help! Select statement syntax for legal reasons
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L@vm.marist.edu>
>
> You could, if you really want a SQL query, run the following SQL on
> a regular basis and dump the output to a file, which will give you a
> listing on the day of the tapes for that criteria:
>
> SELECT VOLUME_NAME from contents where object_id in (SELECT
> object_id FROM backups WHERE node_name LIKE 'LNBRTZM3%5YR' AND
> ll_name LIKE 'training%.nsf')
>
> If that wildcard is supposed to be just one character replace % with
> _ , but I took * in your question to mean 'one or more of any
> character'. Pedantic, but please ignore my own spelling and typos.
>
> However, the query will probably take an age to run and you'll need
> to keep a close eye on the server in case of log pinning etc. I'd
> advise against it if possible.
>
> Note that, as previously noted, a query like this will only give you
> a current snapshot - you seem to be asking which tapes the data was
> on between some dates in the past - I don't know how to do that.
> You could tell the auditors to advise you what data to collect for
> them to query you on at a later date...maybe you need to pull a
> complete TSM database backup out of the cycle and pop it on a shelf
> on a regular basis to keep them happy.
>
> DISCLAIMER - I've not tested that query, it might have errors I've
> not spotted.
>
>
> ----- "Joni M Moyer" <joni.mo...@highmark.com> wrote:
>
>
> >
> > 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
> >
>
