Thanks Del!
If I were looking for lidb88n.nsf files from the server LNBRTZM315YR, then
would the syntax be as follows? I'm trying to find all backup objects during
the time period below? Thanks again!
select * from backups where node_name='LNBRTZM315YR' and backup_date between
'06/30/2008' and '02/01/2009' and ll_name='/mail/lidb88n.nsf.*'?
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Del Hoobler
Sent: Friday, February 10, 2012 8:26 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Help! Select statement syntax for legal reasons
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 AT vm.marist DOT edu> wrote on 02/09/2012
03:44:49 PM:
> From: Xav Paice <xpaice AT OSS.CO DOT NZ>
> To: ADSM-L AT vm.marist DOT 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 AT vm.marist DOT 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.moyer AT HIGHMARK DOT 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 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.
|
