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" wrote on 02/09/2012 03:44:49 PM: > From: Xav Paice > 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" > > 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" 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 > > >
Re: Help! Select statement syntax for legal reasons
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" wrote on 02/09/2012 03:44:49 PM: > From: Xav Paice > 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" > > 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" 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
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" wrote on 02/10/2012 08:35:02 AM: > From: "Moyer, Joni M" > To: ADSM-L@vm.marist.edu > Date: 02/10/2012 08:37 AM > Subject: Re: Help! Select statement syntax for legal reasons > Sent by: "ADSM: Dist Stor Manager" > > 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" wrote on 02/09/2012 > 03:44:49 PM: > > > From: Xav Paice > > 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" > > > > 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" 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.
Re: Help! Select statement syntax for legal reasons
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@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: Friday, February 10, 2012 9:11 AM To: ADSM-L@VM.MARIST.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" wrote on 02/10/2012 08:35:02 AM: > From: "Moyer, Joni M" > To: ADSM-L@vm.marist.edu > Date: 02/10/2012 08:37 AM > Subject: Re: Help! Select statement syntax for legal reasons > Sent by: "ADSM: Dist Stor Manager" > > 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" wrote on 02/09/2012 > 03:44:49 PM: > > > From: Xav Paice > > 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" > > > > 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" 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. >
Isilon backup
Thank you all for the information thus far. Can any of you provide real world backup times for full tree traversal backups to TSM using NDMP? I understand my mileage may vary depending on the data and it's size as well as the hardware configuration but there must be a fairly standard throughput rate for file server data. Lastly I'm not sure I understand why an incremental backup cannot be run on the Isilon. Please explain. Thanks in advance, Jeff +-- |This was sent by jeff.je...@sentry.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +--
Re: Warnings: Latest TSM client for Windows (v6.2.4.1, v6.3.0.5) lacks JRE
I'm not sure about the work-around suggested by Efim. The APAR that's been opened explicitly states this will not help. http://www.ibm.com/support/docview.wss?uid=swg1IC81321&myns=swgtiv&mynp=OCSSGSG7&mync=E Regards Neil Schofield Yorkshire Water Services Ltd. Spotted a leak? If you spot a leak please report it immediately. Call us on 0800 57 3553 or go to http://www.yorkshirewater.com/leaks Get a free water saving pack Don't forget to request your free water and energy saving pack, it could save you money on your utility bills and help you conserve water. http://www.yorkshirewater.com/savewater The information in this e-mail is confidential and may also be legally privileged. The contents are intended for recipient only and are subject to the legal notice available at http://www.keldagroup.com/email.htm Yorkshire Water Services Limited Registered Office Western House, Halifax Road, Bradford, BD6 2SZ Registered in England and Wales No 2366682
Re: Warnings: Latest TSM client for Windows (v6.2.4.1, v6.3.0.5) lacks JRE
I'm absolutely sure that it works on W2008R2. I've tested it before posting. After adding path: C:\Users\Admin>java -version java version "1.6.0" Java(TM) SE Runtime Environment (build pwa6460sr10-20111208_01(SR10)) IBM J9 VM (build 2.4, JRE 1.6.0 IBM J9 2.4 Windows Server 2008 R2 amd64-64 jvmwa 6460sr10-20111207_96808 (JIT enabled, AOT enabled) J9VM - 20111207_096808 JIT - r9_2007_21307ifx1 GC - 20110519_AA) JCL - 2004_02 Efim 2012/2/10 Neil Schofield > I'm not sure about the work-around suggested by Efim. The APAR that's been > opened explicitly states this will not help. > > > http://www.ibm.com/support/docview.wss?uid=swg1IC81321&myns=swgtiv&mynp=OCSSGSG7&mync=E > > Regards > Neil Schofield > Yorkshire Water Services Ltd. > > > > > > Spotted a leak? > If you spot a leak please report it immediately. Call us on 0800 57 3553 > or go to http://www.yorkshirewater.com/leaks > > Get a free water saving pack > Don't forget to request your free water and energy saving pack, it could > save you money on your utility bills and help you conserve water. > http://www.yorkshirewater.com/savewater > > The information in this e-mail is confidential and may also be legally > privileged. The contents are intended for recipient only and are subject to > the legal notice available at http://www.keldagroup.com/email.htm > Yorkshire Water Services Limited > Registered Office Western House, Halifax Road, Bradford, BD6 2SZ > Registered in England and Wales No 2366682 > -- Efim
File integrity check during reclamation?
Has anyone seen any documentation from Tivoli, stating that a file integrity check (or CRC check) is performed during the reclamation process? (In an LTO-4 pool in this case, on TSM 5.5 on AIX.) Thanks, [RC] If you are not the intended addressee, please inform us immediately that you have received this e-mail in error, and delete it. We thank you for your cooperation.
Re: File integrity check during reclamation?
On Feb 10, 2012, at 6:53 PM, Robert A. Clark wrote: > Has anyone seen any documentation from Tivoli, stating that a file > integrity check (or CRC check) is performed during the reclamation > process? Technote 1079385 says no.
