Re: help with designing a backup system for Teradata
Rick, What type of storeage system are you using? Does it have the necessary I/O capability to allow the throughput you are going to require? Best Regards, _ email: ron.delaw...@us.ibm.com From: "Rhodes, Richard L." To: ADSM-L@VM.MARIST.EDU Date: 07/30/15 10:03 Subject:[ADSM-L] help with designing a backup system for Teradata Sent by:"ADSM: Dist Stor Manager" We purchased a Teredata database system. It currently is in test/dev stage with little data. We don't really know the ultimate backup requirements. To get things started we setup a simple backup system: Teradata -> to Bar server (Win) with TSM interface sftw -> to TSM server (AIX) -> to filepool on DataDomain (getting ~5x dedup) From the Bar server to TSM server is a standard 1GB ethernet. Now we need to scale up/out! The consultants are saying we will need to backup 30TB in a 6hr window, but maybe has high as 50TB in 6hr. That is (roughly): 30TB in 6hr = 1,400 MB/sec 50TB in 6hr = 2,300 MB/sec So we need to design a TSM backup system to support this. My thoughts: 1) Put a storage agent on the Bar server (Win server) and feed a VTL via 4x8gb san connections via a bunch of virtual tape. 2) Put the TSM server directly on the Bar server for just local tape and still feed a VTL as above. No library sharing. 3) I'd really like to not use tape (even virtual tape), but I can't think of any way to feed file devices with that throughput. I'd appreciate any thought/comments anyone might have! Thanks Rick - The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message.
Re: help with designing a backup system for Teradata
Anything we do for this has to be purchased, so current licensing is not a problem. I'm not sure what using DDBoost would look like. Where would the plugin run? I don't think there is a DDboost plugin for TSM or Teradata's program. I know there are plugins for Networker, NetBackup, Oracle/RMAN and others, but I don't think for Teradata. Yea, it would really be nice to just bypass TSM altogether, but the Teradata backup program doesn't support backup-to-disk. It want's to feed an API interface, like TSM's API client. Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Mike De Gasperis Sent: Thursday, July 30, 2015 2:16 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: help with designing a backup system for Teradata Do you have DDboost licensed? Could always use the boost plugin and go right to the DD and skip the TSM server. > On Jul 30, 2015, at 1:00 PM, Rhodes, Richard L. > wrote: > > We purchased a Teredata database system. > It currently is in test/dev stage with little data. > We don't really know the ultimate backup requirements. > To get things started we setup a simple backup system: > > Teradata >-> to Bar server (Win) with TSM interface sftw >-> to TSM server (AIX) >-> to filepool on DataDomain (getting ~5x dedup) > > From the Bar server to TSM server is a standard 1GB ethernet. > > Now we need to scale up/out! > > The consultants are saying we will need to backup 30TB in a 6hr window, > but maybe has high as 50TB in 6hr. > That is (roughly): > 30TB in 6hr = 1,400 MB/sec > 50TB in 6hr = 2,300 MB/sec > > So we need to design a TSM backup system to support this. > > My thoughts: > > 1) Put a storage agent on the Bar server (Win server) > and feed a VTL via 4x8gb san connections via a bunch of virtual tape. > > 2) Put the TSM server directly on the Bar server for just > local tape and still feed a VTL as above. > No library sharing. > > 3) I'd really like to not use tape (even virtual tape), > but I can't think of any way to feed file devices > with that throughput. > > I'd appreciate any thought/comments anyone might have! > > Thanks > > Rick > > > > > - > The information contained in this message is intended only for the personal > and confidential use of the recipient(s) named above. If the reader of this > message is not the intended recipient or an agent responsible for delivering > it to the intended recipient, you are hereby notified that you have received > this document in error and that any review, dissemination, distribution, or > copying of this message is strictly prohibited. If you have received this > communication in error, please notify us immediately, and delete the original > message. - The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message.
Re: help with designing a backup system for Teradata
Do you have DDboost licensed? Could always use the boost plugin and go right to the DD and skip the TSM server. > On Jul 30, 2015, at 1:00 PM, Rhodes, Richard L. > wrote: > > We purchased a Teredata database system. > It currently is in test/dev stage with little data. > We don't really know the ultimate backup requirements. > To get things started we setup a simple backup system: > > Teradata >-> to Bar server (Win) with TSM interface sftw >-> to TSM server (AIX) >-> to filepool on DataDomain (getting ~5x dedup) > > From the Bar server to TSM server is a standard 1GB ethernet. > > Now we need to scale up/out! > > The consultants are saying we will need to backup 30TB in a 6hr window, > but maybe has high as 50TB in 6hr. > That is (roughly): > 30TB in 6hr = 1,400 MB/sec > 50TB in 6hr = 2,300 MB/sec > > So we need to design a TSM backup system to support this. > > My thoughts: > > 1) Put a storage agent on the Bar server (Win server) > and feed a VTL via 4x8gb san connections via a bunch of virtual tape. > > 2) Put the TSM server directly on the Bar server for just > local tape and still feed a VTL as above. > No library sharing. > > 3) I'd really like to not use tape (even virtual tape), > but I can't think of any way to feed file devices > with that throughput. > > I'd appreciate any thought/comments anyone might have! > > Thanks > > Rick > > > > > - > The information contained in this message is intended only for the personal > and confidential use of the recipient(s) named above. If the reader of this > message is not the intended recipient or an agent responsible for delivering > it to the intended recipient, you are hereby notified that you have received > this document in error and that any review, dissemination, distribution, or > copying of this message is strictly prohibited. If you have received this > communication in error, please notify us immediately, and delete the original > message.
help with designing a backup system for Teradata
We purchased a Teredata database system. It currently is in test/dev stage with little data. We don't really know the ultimate backup requirements. To get things started we setup a simple backup system: Teradata -> to Bar server (Win) with TSM interface sftw -> to TSM server (AIX) -> to filepool on DataDomain (getting ~5x dedup) From the Bar server to TSM server is a standard 1GB ethernet. Now we need to scale up/out! The consultants are saying we will need to backup 30TB in a 6hr window, but maybe has high as 50TB in 6hr. That is (roughly): 30TB in 6hr = 1,400 MB/sec 50TB in 6hr = 2,300 MB/sec So we need to design a TSM backup system to support this. My thoughts: 1) Put a storage agent on the Bar server (Win server) and feed a VTL via 4x8gb san connections via a bunch of virtual tape. 2) Put the TSM server directly on the Bar server for just local tape and still feed a VTL as above. No library sharing. 3) I'd really like to not use tape (even virtual tape), but I can't think of any way to feed file devices with that throughput. I'd appreciate any thought/comments anyone might have! Thanks Rick - The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message.
Re: Aw: Re: [ADSM-L] TSM TDPSQL crashes on log backup
Supposedly fixed in 7.1.3 in Q3 which might mean the end of September. When IBM blunders like this I think they could be quicker in correcting it. They should also extend their testing to something that at least faintly resembles a customer environment. Hans Chr. On Wed, Jul 29, 2015 at 4:43 PM, Zoltan Forray wrote: > The alternative (which my SQL guy decided to implement) is to single-thread > the backups, 1-DB-at-a-time. It is ugly (and generates lots of error > messages on my TSM server) but since this version is required for 2014 > server with mirrored DB's, he didn't have much of a choice. > > On Wed, Jul 29, 2015 at 10:25 AM, John Keyes wrote: > > > Thanks for the answer. I tried the patch anyway, but as you said, it did > > not work. > > Now I downgraded to 7.1.1.1 and it works again. > > > > Best regards, > > John > > > > > > > Gesendet: Mittwoch, 29. Juli 2015 um 14:33 Uhr > > > Von: "Zoltan Forray" > > > An: ADSM-L@VM.MARIST.EDU > > > Betreff: Re: [ADSM-L] TSM TDPSQL crashes on log backup > > > > > > If you go look at the ADSM-L archives you will see I just went through > > this > > > exact same problem, a week or so ago. It is a known problem: > > > > > > > > > http://www.backupcentral.com/phpBB2/two-way-mirrors-of-external-mailing-lists-3/ibm-tsm-13/issued-with-tdp-sql-7-1-2-0-and-2014-sql-server-128607/ > > > > > > IT09192: DATABASE BACKUPS USING DATA PROTECTION FOR SQL CAN CRASH > DURING > > > PROCESSING WITH REFERENCES TO MODULE CLR.DLL > > > > > > IBM recently released TDP SQL patch 7.1.2.1 but it DOES NOT fix this > > > problem fully/yet - at least not on our system with this issue. The > APAR > > > discussed 2-problem and the FIN mentioned is 7.1.3. > > > > > > On Wed, Jul 29, 2015 at 6:16 AM, John Keyes wrote: > > > > > > > Hello, > > > > > > > > i have a strange problem with one of my SQL Servers. It's a SQL > Server > > > > 2014, running on Windows Server 2012 R2. TSM BA and TDPSQL are > > installed in > > > > version 7.1.2.0. Most Databases use a simple recovery plan, but a few > > have > > > > a transaction log. VSS Full Backups are working fine as always. We > set > > the > > > > whole thing up a few weeks ago, but since last week every log backup, > > or > > > > even legacy full backup for that matter, causes the TSM software to > > crash. > > > > There are no error reports in the tsm log files, the windows event > > viewer > > > > shows this: > > > > Faulting application name: tdpsqlc.exe, version: 7.1.2.0, time stamp: > > > > 0x55102a96 > > > > Faulting module name: clr.dll, version: 4.0.30319.34209, time stamp: > > > > 0x5348a1ef > > > > Exception code: 0xc409 > > > > Fault offset: 0x00355714 > > > > Faulting process id: 0x1838 > > > > Faulting application start time: 0x01d0c9e477c55264 > > > > Faulting application path: C:\Progra~1\Tivoli\TSM\TDPSql\tdpsqlc.exe > > > > Faulting module path: > > > > C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clr.dll > > > > Report Id: bfee8f36-35d7-11e5-80cb-00155dfd9cbb > > > > Faulting package full name: > > > > Faulting package-relative application ID: > > > > > > > > I also rebootet the server and reinstalled TSM, but to no avail. Does > > > > anyone have any ideas? > > > > > > > > > > > > Kind Regards, > > > > John > > > > > > > > > > > > > > > > -- > > > *Zoltan Forray* > > > TSM Software & Hardware Administrator > > > Xymon Monitor Administrator > > > Virginia Commonwealth University > > > UCC/Office of Technology Services > > > www.ucc.vcu.edu > > > zfor...@vcu.edu - 804-828-4807 > > > Don't be a phishing victim - VCU and other reputable organizations will > > > never use email to request that you reply with your password, social > > > security number or confidential personal information. For more details > > > visit http://infosecurity.vcu.edu/phishing.html > > > > > > > > > -- > *Zoltan Forray* > TSM Software & Hardware Administrator > Xymon Monitor Administrator > Virginia Commonwealth University > UCC/Office of Technology Services > www.ucc.vcu.edu > zfor...@vcu.edu - 804-828-4807 > Don't be a phishing victim - VCU and other reputable organizations will > never use email to request that you reply with your password, social > security number or confidential personal information. For more details > visit http://infosecurity.vcu.edu/phishing.html >
