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@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: Friday, February 10, 2012 8:26 AM To: ADSM-L@VM.MARIST.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@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 > > > ________________________________ 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.
