Re: Mount Wait with LTO drives
We have a 3584 Library with for LTO SCSI drives connected to the SAN using a Gateway. When we backup a SQl database, we seem the tape mount within 20 seconds, but it then seems to take 2 -3 minutes before the data is streamed straight to the tape. We are using LAN free backup. Anybody any idea why it takes so long to start sending data to the tape? You didn't specify whether this was a scratch tape or one that was Filling, but probably the latter, in which positioning has to occur. You can check this by watching the drive's display: it will show Tape Loading... followed by Locating... (It takes 3590s a while to position, too.) Your level of microcode can influence how long the positioning takes, with transport speed being the limiting factor. Richard Sims, BU
Mount Wait with LTO drives
All We have a 3584 Library with for LTO SCSI drives connected to the SAN using a Gateway. When we backup a SQl database, we seem the tape mount within 20 seconds, but it then seems to take 2 -3 minutes before the data is streamed straight to the tape. We are using LAN free backup. Anybody any idea why it takes so long to start sending data to the tape? Thanks Sean Dudding EMAIL: [EMAIL PROTECTED] Tel: 0207 268 6774 Fax: 0207 268 1836 __ Registered Office: Marks and Spencer p.l.c Michael House, Baker Street, London, W1U 8EP Registered No. 214436 in England and Wales. Telephone (020) 7935 4422 Facsimile (020) 7487 2670 www.marksandspencer.com Please note that electronic mail may be monitored. This e-mail is confidential. If you received it by mistake, please let us know and then delete it from your system; you should not copy, disclose, or distribute its contents to anyone nor act in reliance on this e-mail, as this is prohibited and may be unlawful _
Sun client error
Hi *SM-ers! One of my Sun TSM clients reports error 195 during backups. This seems to be related to APAR IC26775: CLIENT BACKUPS FAIL WITH RETURN CODE 195 I have downloaded IC26775.tar.Z and installed the 3.7.2.14 client which is supposed to fix this problem, but I still see the error. The strange thing is that I can see in the Sun installation logs that IC26775 has been installed, but when I start DSMC it still reports level 3.7.2. Now I'm confused. Shouldn't it report 3.7.2.14 or is the version number not updated in this new code? I hope somebody can shed some light on this. Thanks in advance for any reply!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: How to migrate TSM from OS/390 onto AIX
We used server to server to export the nodes to an AIX TSM server. We had a 20gig database with several hundred nodes that we migrated. We did the migration a node at a time over a 4 month period. We would lock the node, do the export, then import on the AIX server, add the node to a schedule, and then notify the customer that he needed to change the ip address for the TSM server. You need a lot of patience because if you get an error there is no way to restart the export where you left off. For some of our larger nodes we ended up exporting them a filespace or several filespaces at a time. Jim Sporer At 10:49 AM 6/8/2001 +0200, you wrote: Hello, we will stop our mainframe by end of the year. TSM will be migrated from OS/390 to AIX. I have a 15 GB DB, about 2500 primary volumes as 3590 cartridges. How should we proceed: - export / import DB: using which media ?, server to server ? - same question for the stg pools: can AIX read the OS/390 cart or do we have to export / import between both. If yes export onto what media ? - no export but keep a mini-mainframe for the time to expire old backups ? Thanks for any advices, René Lambelet Nestec S.A. / Informatique du Centre 55, av. Nestlé CH-1800 Vevey (Switzerland) *+41'21'924'35'43 7+41'21'924'28'88 * K4-117 email [EMAIL PROTECTED] Visit our site: http://www.nestle.com This message is intended only for the use of the addressee and may contain information that is privileged and confidential.
Error 6 killing thread (#)
Hello all, Has anyone seen this error and can someone suggest a fix for it? The error appears in the dsmerror.log while the clients' WinNT and W2K workstations (running TSM V4.1) are in the process of shutting down. The error is accompanied by the message (that pops up on the screen) dsmcsvc.exe Application Error, address in memory could not be referenced. This may not be a big problem, but users find these messages very annoying. Thanks in advance, Arthur --- The information contained in this e-mail message, and any attachment thereto, is confidential and may not be disclosed without our express permission. If you are not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that you have received this message in error and that any review, dissemination, distribution or copying of this message, or any attachment thereto, in whole or in part, is strictly prohibited. If you have received this message in error, please immediately notify us by telephone, fax or e-mail and delete the message and all of its attachments. Thank you. Every effort is made to keep our network free from viruses. You should, however, review this e-mail message, as well as any attachment thereto, for viruses. We take no responsibility and have no liability for any computer virus which may be transferred via this e-mail message.
Re: IBM ESS Model 2105-F20
If you have more then one path going to data then you need to run cfgmgr for each path. For example if you have 3 paths then you often need to run cfgmgr 3 times to get all of the paths. Becky -Original Message- From: Van Ruler, Ruud R SSI-ISES-31 [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 10:18 AM To: [EMAIL PROTECTED] Subject: IBM ESS Model 2105-F20 Guys this is not really a TSM matter but perhaps someone could help me out here: At the moment we have a concerning situation on a ESS. When we change ESS-ports for an AIX-server without touching the assigned LUN's of the server, only a Hba-swap on the ESS, our customers complain about the availability of the disks from the servers point of view. They say that after we performed this action and they have deleted the disks, rebooted the server and ran config-manager, they still have missing disks (some disks are visible, but not all of them), note that before the Hba-swap, the server could see all its disks. When they boot the server again a couple of days later, all the disks are visible again without us performing any actions on the ESS or the switches. any ideas ??? thanks Ruud van Ruler, Shell Services International BV - ISES/31 Our Central Data Storage Management home page: http://sww2.shell.com/cdsm/ Room 1B/G01 Dokter van Zeelandstraat 1, 2285 BD Leidschendam NL Tel : +31 (0)70 - 3034644, Fax 4011, Mobile +31 (0)6-55127646 Email Internet: [EMAIL PROTECTED] [EMAIL PROTECTED] R.vanRuler
IBM ESS Model 2105-F20
Guys this is not really a TSM matter but perhaps someone could help me out here: At the moment we have a concerning situation on a ESS. When we change ESS-ports for an AIX-server without touching the assigned LUN's of the server, only a Hba-swap on the ESS, our customers complain about the availability of the disks from the servers point of view. They say that after we performed this action and they have deleted the disks, rebooted the server and ran config-manager, they still have missing disks (some disks are visible, but not all of them), note that before the Hba-swap, the server could see all its disks. When they boot the server again a couple of days later, all the disks are visible again without us performing any actions on the ESS or the switches. any ideas ??? thanks Ruud van Ruler, Shell Services International BV - ISES/31 Our Central Data Storage Management home page: http://sww2.shell.com/cdsm/ Room 1B/G01 Dokter van Zeelandstraat 1, 2285 BD Leidschendam NL Tel : +31 (0)70 - 3034644, Fax 4011, Mobile +31 (0)6-55127646 Email Internet: [EMAIL PROTECTED] [EMAIL PROTECTED] R.vanRuler
Delete Archive.
Hello everyone, We are running TSM 3.7.4 on OS/390 2.10 and I have a RS/6000 AIX 4.3 and the TSM 3.7.2 client and I have a question on the Delete Archive command. I have a UNIX client and the administrator of this node has been doing some cleanup of the Archive data for this node by issuing the Delete Archive command from the clients command line. I did check the client access to ensure that they had the ability to delete archives and that parameter is set correctly and I can see sessions active for the node when the administrator is running the deletes. I do not see any processes active when the deletes are running from the TSM server. According to the administrator there were several thousand files deleted from this node but when I issue the Q OCC command for the node the number of files has not changed since before the deletes were run. I also expected to see our data base percentage decrease. We did run expiration after the Delete Archive command had completed but no decrease in any of the items mentioned earlier has occurred.
Re: Delete Archive.
According to the administrator there were several thousand files deleted from this node but when I issue the Q OCC command for the node the number of files has not changed since before the deletes were run. I also expected to see our data base percentage decrease. We did run expiration after the Delete Archive command had completed but no decrease in any of the items mentioned earlier has occurred. Brian - You didn't say whether the final ANR0812I message from the Expire Inventory reported that archive files were deleted. Run the Expire Inventory with Quiet=No to assure that it visits the filespace that your client supposedly deleted files from. And run it without a limiting Duration value so that it doesn't stop prematurely. Try to get from the client a log of the deletions to assure that they actually occurred. Unfortunately, TSM doesn't let us SQL-query the flagging involved in archive files so that we can see if they have been marked for deletion. (In the Archives table, they look the same before and after Delete Archive.) And, in all this, we presume that your client means files that were archived with the standard client, as only those are treated by Expire Inventory: files sent to the server via some API (which your client may loosely term as archiving) have to expired via the API. Richard Sims, BU
Re: TDP for MS SQL cross server restore
Joel, From the TDP for SQL 2.2 README file... Backups made with TDP for MS SQL Version 1 CANNOT be queried or restored using Version 2 nor can backups made with Version 2 be queried or restored using Version 1. You must keep TDP for MS SQL Version 1 for as long as you have Version 1 backups that may need to be restored. There is a longer explanation on why in the User's Guide. Look at a section titled: Version Migration/Coexistence Considerations OK. So what can you do? Install version 1 on Host-B (both V1 and V2 will coexist nicely) and restore your database. Thanks, Del Del Hoobler IBM Corporation [EMAIL PROTECTED] It's a beautiful day. Don't let it get away. -- Bono Joel Fuhrman [EMAIL PROTECTED] To: [EMAIL PROTECTED] NGTON.EDU cc: Sent by: ADSM:Subject: TDP for MS SQL cross server restore Dist Stor Manager [EMAIL PROTECTED] T.EDU 06/11/2001 01:58 PM Please respond to ADSM: Dist Stor Manager I have 2 Windows 2000 servers each running MS SQL7. The old machine, Host-A, is running TDP for MS SQL version 1.1.2.01 while the new machine, Host-B, is running version 2.2. I want to restore a database that was backed up on Host-A to Host-B. When I attempt to view the backup tree for Host-A on Host-B's tdpsql gui screen, nothing is displayed and the TSM server logs this error: ANRD smnode.c(5323): Error validating inserts for event 14995. Any suggestions as to what is wrong?
Re: TSM vs. Veritas
Hello - there was a discussion in the fall of 2000 (i think sept-nov time period) about the merits of both. serach for would you buy tsm again that is the suggestion from the mailing list archives (http://www.adsm.org) -j On Mon, 11 Jun 2001, PINNI, BALANAND (SBCSI) wrote: Hi STEPHEN I am also looking for the same. Veritas on WIN NT can get back applications well on restore but not with tivoli. Data files restoration are fine with tsm on NT. -Original Message- From: Stephen A. Cochran [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 12:25 PM To: [EMAIL PROTECTED] Subject: TSM vs. Veritas Anyone done a through comparison between TSM and Veritas. TSM is used as the main system here, but veritas is used with some NAS which houses our main Oracle database. There's a small push to consolidate to one solution, so I'm looking for feedback. Steve Cochran Dartmouth College John Jamie Marquart | This message posted 100% MS free. Digital Library SysAdmin| Work: 812-856-5174 Pager: 812-334-6018 Indiana University Libraries| ICQ: 1131494 D'net Team: 6265
Re: TSM 3.7.2 client
Andy, What Operating Systems need to be eliminated prior to this date to maintain a supported level of ADSM in an environment? How is this communicated to your customers? HP10.20, NCR, AIX 4 ..., Auspex 2.***, NT4.0 ?? Jeff Bach Home Office Open Systems Engineering Wal-Mart Stores, Inc. WAL-MART CONFIDENTIAL -Original Message- From: Andy Raibeck [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 1:35 PM To: [EMAIL PROTECTED] Subject:Re: TSM 3.7.2 client Hello Brian, The TSM clients go out of service when their corresponding server version goes out of service. The end-of-service matrix shows that TSM 3.7 for OS/390 goes out of service on September 30; for other platforms it is October 31. This includes both server and client. Regards, Andy Andy Raibeck IBM Tivoli Systems Tivoli Storage Manager Client Development e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend Brian Nick [EMAIL PROTECTED]@VM.MARIST.EDU on 06/08/2001 05:26:48 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: TSM 3.7.2 client Hello everyone. I have been doing some research this morning trying to locate the end of service date for the TSM 3.7.2 client for all platforms. I have been able to locate the end of service for the TSM server (3.7.4) but not for the 3.7.2 client. I would like to go to the 4.1.2.12 client version for WIN but I am receiving some resistance. Could some one please point me to the site that contains this information? I have been on the Tivoli web site but I have been unable to locate dates for the clients. Thanks for all your help. - Brian Brian L. Nick Systems Technician - Storage Solutions Phoenix Home Life Mutual Ins. 100 Bright Meadow Blvd Enfield CT. 06082-1900 E-MAIL: [EMAIL PROTECTED] PHONE: (860)403-2281 ** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. **
SYNCSORT Backup Express
My Disaster Recovery Administrator inquired about a product call Syncsort Backup Express. Does anyone have any information about this product or is anyone using it?
Backup a BIG Sap installation
We have a potential client that wants to backup a 1.2TB SAP database in a 3-hour window. Currently they are using Omniback and an HP SureStore library with 10 LTO drives SCSI attached. If we were to repace Omniback with a TSM server on the SAP server, using those same LTO drives and TDP for SAP, would this be possible? I'm looking for some real world opinions. Right now I think they stop SAP and backup the database files. I do not believe they are using SAPDBA. Thanks, Bill Boyer He who laughs last... probably did a backup! - ???
Re: TSM 3.7.2 client
Jeff, You can check the Tivoli web site (www.tivoli.com) and look at the client requirements to determine which OS's are supported at which client versions. The direct page is http://www.tivoli.com/support/storage_mgr/clients.html. When we announce new products, the announcement includes the client platforms supported by that product. Aside from that, I really do not know what other mechanisms our Marketing team has to get the word out. If you have a relationship with your local IBM branch office, then hopefully they are keeping you apprised of new developments; you should check with them. Regards, Andy Andy Raibeck IBM Tivoli Systems Tivoli Storage Manager Client Development e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend Jeff Bach [EMAIL PROTECTED]@VM.MARIST.EDU on 06/11/2001 11:50:27 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: Re: TSM 3.7.2 client Andy, What Operating Systems need to be eliminated prior to this date to maintain a supported level of ADSM in an environment? How is this communicated to your customers? HP10.20, NCR, AIX 4 ..., Auspex 2.***, NT4.0 ?? Jeff Bach Home Office Open Systems Engineering Wal-Mart Stores, Inc. WAL-MART CONFIDENTIAL -Original Message- From: Andy Raibeck [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 1:35 PM To: [EMAIL PROTECTED] Subject:Re: TSM 3.7.2 client Hello Brian, The TSM clients go out of service when their corresponding server version goes out of service. The end-of-service matrix shows that TSM 3.7 for OS/390 goes out of service on September 30; for other platforms it is October 31. This includes both server and client. Regards, Andy Andy Raibeck IBM Tivoli Systems Tivoli Storage Manager Client Development e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend Brian Nick [EMAIL PROTECTED]@VM.MARIST.EDU on 06/08/2001 05:26:48 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: TSM 3.7.2 client Hello everyone. I have been doing some research this morning trying to locate the end of service date for the TSM 3.7.2 client for all platforms. I have been able to locate the end of service for the TSM server (3.7.4) but not for the 3.7.2 client. I would like to go to the 4.1.2.12 client version for WIN but I am receiving some resistance. Could some one please point me to the site that contains this information? I have been on the Tivoli web site but I have been unable to locate dates for the clients. Thanks for all your help. - Brian Brian L. Nick Systems Technician - Storage Solutions Phoenix Home Life Mutual Ins. 100 Bright Meadow Blvd Enfield CT. 06082-1900 E-MAIL: [EMAIL PROTECTED] PHONE: (860)403-2281 ** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. **
Re: Backup a BIG Sap installation
We backup about a 1 TB SAP Database nightly hot. We use a disk pool and SQL Backtrack with 16 threads and then drain the disk pool to 3590 tape drives. We do it in 3-4 hours. We will be implementing TDP for SAP on production soon we are currently running it only in development. I would suspect it would be possible but I am not sure with just 10 drives. You would definitely want at least TDP 3.2 because there are issues with compression on 3.1 Good luck and let us know how you do if you do. Becky -Original Message- From: William Boyer [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 2:29 PM To: [EMAIL PROTECTED] Subject: Backup a BIG Sap installation We have a potential client that wants to backup a 1.2TB SAP database in a 3-hour window. Currently they are using Omniback and an HP SureStore library with 10 LTO drives SCSI attached. If we were to repace Omniback with a TSM server on the SAP server, using those same LTO drives and TDP for SAP, would this be possible? I'm looking for some real world opinions. Right now I think they stop SAP and backup the database files. I do not believe they are using SAPDBA. Thanks, Bill Boyer He who laughs last... probably did a backup! - ???
Re: TSM vs. Veritas
I guess I'm confused about the comment that TSM can't restore applications. I know that isn't true. What is your perception? Kelly J. Lipp Storage Solutions Specialists, Inc. PO Box 51313 Colorado Springs CO 80949-1313 (719) 531-5926 Fax: (240) 539-7175 Email: [EMAIL PROTECTED] or [EMAIL PROTECTED] www.storsol.com www.storserver.com -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of PINNI, BALANAND (SBCSI) Sent: Monday, June 11, 2001 12:23 PM To: [EMAIL PROTECTED] Subject: Re: TSM vs. Veritas Importance: Low Hi STEPHEN I am also looking for the same. Veritas on WIN NT can get back applications well on restore but not with tivoli. Data files restoration are fine with tsm on NT. -Original Message- From: Stephen A. Cochran [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 12:25 PM To: [EMAIL PROTECTED] Subject: TSM vs. Veritas Anyone done a through comparison between TSM and Veritas. TSM is used as the main system here, but veritas is used with some NAS which houses our main Oracle database. There's a small push to consolidate to one solution, so I'm looking for feedback. Steve Cochran Dartmouth College
Re: SYNCSORT Backup Express
Check the website syncsort.com. It is backu-restore for vaious platforms. -Original Message- From: David Browne. [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 12:22 PM To: [EMAIL PROTECTED] Subject: SYNCSORT Backup Express My Disaster Recovery Administrator inquired about a product call Syncsort Backup Express. Does anyone have any information about this product or is anyone using it?
Re: TSM vs. Veritas
Kelly We used Arch serve also on NT systems and is works fine to restore all the system files and what I ment was applications like sql,MACFEE ,PC anywhere. But with TSM it didn't do that on NT PLATFORMS. COULD U BACKUP THESE WITH TSM RESTORE BACK WELL. WITHOUT INSTALLING SYSTEM FILES AGAIN. COULD U DO USING TSM. That is if u had c: drive as SQL and all files and I backup as total and restore back .Did the system files applications work ok?Is ur registry with those applications intact.? PL note we get screens for each application but when sub process icons are clicked binding problems were found. What is ur suggestion.I request u to kindly give feedback. Thankx. BALANAND PINNI. PHONE 314-206-5911. EM:[EMAIL PROTECTED] PG:1-800-451-6897. -Original Message- From: Kelly J. Lipp [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 2:22 PM To: [EMAIL PROTECTED] Subject: Re: TSM vs. Veritas I guess I'm confused about the comment that TSM can't restore applications. I know that isn't true. What is your perception? Kelly J. Lipp Storage Solutions Specialists, Inc. PO Box 51313 Colorado Springs CO 80949-1313 (719) 531-5926 Fax: (240) 539-7175 Email: [EMAIL PROTECTED] or [EMAIL PROTECTED] www.storsol.com www.storserver.com -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of PINNI, BALANAND (SBCSI) Sent: Monday, June 11, 2001 12:23 PM To: [EMAIL PROTECTED] Subject: Re: TSM vs. Veritas Importance: Low Hi STEPHEN I am also looking for the same. Veritas on WIN NT can get back applications well on restore but not with tivoli. Data files restoration are fine with tsm on NT. -Original Message- From: Stephen A. Cochran [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 12:25 PM To: [EMAIL PROTECTED] Subject: TSM vs. Veritas Anyone done a through comparison between TSM and Veritas. TSM is used as the main system here, but veritas is used with some NAS which houses our main Oracle database. There's a small push to consolidate to one solution, so I'm looking for feedback. Steve Cochran Dartmouth College
Re: Backup a BIG Sap installation
Bill, what are the SAP and TSM platforms? I'm doing a 540 GB SAP database in 3.0 hours to 5 DLT-7000 drives. My bottleneck is the drives - I'm averaging 9 MB/sec per drive (45 MB/sec over the 3 hour window). We're planning on LTO drives in the 3rd quarter and I expect to move the bottleneck to the network. I'm on an 4 GB S7A (RS/6000) with 8 CPUs and 3 fiber-channel attachments to an ESS for the SAP database server, and a 4 GB S7A with 4 CPUs as the TSM server. My tape drives are SCSI, two to an adapter card, and I have two independant gigabit ethernet networks between the systems. I run three sessions on one network and two on the other -- we use backint to interface between SAP/Oracle and TSM on the SAP DB box. One thing I've found is that I get better throughput with TSM on a seperate box. Our TSM server is the SAP DB fallover box, and when both environments are running on the same system all the IP traffic gets run through the loopback interface. Short answer -- should fit with no real problem given the number of tape drives available. Long answer -- If TSM and SAP servers both live on the same box, you'll get the backups into the window, but on-line backups will probably busy things out so much that they might as well be off-line backups. Tom Kauffman NIBCO, Inc. -Original Message- From: William Boyer [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 2:29 PM To: [EMAIL PROTECTED] Subject: Backup a BIG Sap installation We have a potential client that wants to backup a 1.2TB SAP database in a 3-hour window. Currently they are using Omniback and an HP SureStore library with 10 LTO drives SCSI attached. If we were to repace Omniback with a TSM server on the SAP server, using those same LTO drives and TDP for SAP, would this be possible? I'm looking for some real world opinions. Right now I think they stop SAP and backup the database files. I do not believe they are using SAPDBA. Thanks, Bill Boyer He who laughs last... probably did a backup! - ???
Re: Backup a BIG Sap installation
Tom, Excellent description! I find your assertion that using two different boxes and the network is faster than both apps on the same box. Intuitively I would have guessed that due to loading, but most folks do just the opposite assuming the network will be the bottleneck. With today's network hardware, rarely will the network bottleneck. Kelly J. Lipp Storage Solutions Specialists, Inc. PO Box 51313 Colorado Springs CO 80949-1313 (719) 531-5926 Fax: (240) 539-7175 Email: [EMAIL PROTECTED] or [EMAIL PROTECTED] www.storsol.com www.storserver.com -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Kauffman, Tom Sent: Monday, June 11, 2001 2:22 PM To: [EMAIL PROTECTED] Subject: Re: Backup a BIG Sap installation Bill, what are the SAP and TSM platforms? I'm doing a 540 GB SAP database in 3.0 hours to 5 DLT-7000 drives. My bottleneck is the drives - I'm averaging 9 MB/sec per drive (45 MB/sec over the 3 hour window). We're planning on LTO drives in the 3rd quarter and I expect to move the bottleneck to the network. I'm on an 4 GB S7A (RS/6000) with 8 CPUs and 3 fiber-channel attachments to an ESS for the SAP database server, and a 4 GB S7A with 4 CPUs as the TSM server. My tape drives are SCSI, two to an adapter card, and I have two independant gigabit ethernet networks between the systems. I run three sessions on one network and two on the other -- we use backint to interface between SAP/Oracle and TSM on the SAP DB box. One thing I've found is that I get better throughput with TSM on a seperate box. Our TSM server is the SAP DB fallover box, and when both environments are running on the same system all the IP traffic gets run through the loopback interface. Short answer -- should fit with no real problem given the number of tape drives available. Long answer -- If TSM and SAP servers both live on the same box, you'll get the backups into the window, but on-line backups will probably busy things out so much that they might as well be off-line backups. Tom Kauffman NIBCO, Inc. -Original Message- From: William Boyer [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 2:29 PM To: [EMAIL PROTECTED] Subject: Backup a BIG Sap installation We have a potential client that wants to backup a 1.2TB SAP database in a 3-hour window. Currently they are using Omniback and an HP SureStore library with 10 LTO drives SCSI attached. If we were to repace Omniback with a TSM server on the SAP server, using those same LTO drives and TDP for SAP, would this be possible? I'm looking for some real world opinions. Right now I think they stop SAP and backup the database files. I do not believe they are using SAPDBA. Thanks, Bill Boyer He who laughs last... probably did a backup! - ???
TSM 4.1 / TDS / UDB
A colleague is working on implementing the TDS / TSM integration. We're using TSM 4.1, TDS Core 2.1.1, TSM Data Loader 4.2 and UDB 6.1 (on AIX). Any attempts to connect from the TSM Data Loader on NT to the AIX UDB database is failing; we can however show that the ODBC connection IS working (likewise, the ODBC connection to TSM 4.1 IS working). Are there any guru's out there who have got this combination working and would be willing to exchange a few eMails??? Thanks Peter Thomas
Re: Backup a BIG Sap installation
Hallo, we backup nearly twenty SAP DBs with TSM 4.1 and SQL Backtrack from BMC. Our biggest DB is now around 450 GB. We use 3590 drives (FC connected to a SUN E450). The network interface is a dedicated switched gigabit ethernet for all SAP DB server. Our experiences are: With two streams and SQL BT compression we backup 450 GB in 2 hours 20 minutes. Due to the lack of more drives we cannot use four streams in production, which would use all the network bandwith we have and reduce the backup time to a bit more than 1 hour. Compression rate is nearly 70 % (SAP DBs have a lot of unused space in it). We saw transmission rates of nearly 35 MB/s (so 100% drive speed). Herzliche Gruesse / Many greetings Info Business Systems GmbH Rolf Meyer [EMAIL PROTECTED]
IBM 3600-109/220/R20 LTO with TSM
Hi all, does anybody some experience with these devices in TSM?: 1. 3600-109 LTO Autoloader 2. 3600-220 (R20) LTO Tape Library The first one is 9-slot LTO Autoloader (i mean equivalent to IBM 3581 7-slot Autoloader), second one is LTO Tape Library (1-2 drives, 20 slots no more scalable). In TSM device support list are not listed these devices, but I'd like to get some references, if somebody tried them to use with TSM. Thanx TOM Tom Hrouda, AGCOM Smiice Tivoli Certified Consultant Storage Manager Specialist [EMAIL PROTECTED] +420 49 5941312, +420 604 296521 ICQ#77892561 --- Odchoz zprva neobsahuje viry. Zkontrolovno antivirovm systmem AVG (http://www.grisoft.cz). Verze: 6.0.237 / Virov bze: 115 - datum vydn: 7.3.2001