Thanks Del!
I actually figured out what works: select * from backups where
node_name='LNBRTZM315YR' and backup_date between '06/30/2008' and '02/01/2009'
and ll_name like '%lidz4dx%' but now I'm trying to find the tape this object is
on and that's taking quite a while. I'm not even sure it will return a result
at this point in time.
Thanks again!
-----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 9:11 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Help! Select statement syntax for legal reasons
Hi Joni,
Sorry... I am not a SQL expert. I will let one of the other
SQL experts assist with your question. I just wanted to make sure
that you had the correct object names.
Thanks,
Del
----------------------------------------------------
"ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu> wrote on 02/10/2012
08:35:02 AM:
> From: "Moyer, Joni M" <joni.moyer AT HIGHMARK DOT COM>
> To: ADSM-L AT vm.marist DOT edu
> Date: 02/10/2012 08:37 AM
> Subject: Re: Help! Select statement syntax for legal reasons
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
>
> 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.
>
|
