Re: Help! Select statement syntax for legal reasons

2012-02-10 Thread Del Hoobler
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 exten

Re: Help! Select statement syntax for legal reasons

2012-02-10 Thread Moyer, Joni M
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' a

Re: Help! Select statement syntax for legal reasons

2012-02-10 Thread Del Hoobler
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:0

Re: Help! Select statement syntax for legal reasons

2012-02-10 Thread Moyer, Joni M
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 wi

Isilon backup

2012-02-10 Thread EVILUTION
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 throughpu

Re: Warnings: Latest TSM client for Windows (v6.2.4.1, v6.3.0.5) lacks JRE

2012-02-10 Thread 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.

Re: Warnings: Latest TSM client for Windows (v6.2.4.1, v6.3.0.5) lacks JRE

2012-02-10 Thread Efim
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 6

File integrity check during reclamation?

2012-02-10 Thread Robert A. Clark
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 r

Re: File integrity check during reclamation?

2012-02-10 Thread Richard Sims
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.