David,
Here is the list of the things to check:
(1) make sure hardware compression is enabled on your tape drives
(2) make sure TSM does NOT compress data
(3) Oracle server should have enough CPU power to push data, especially if
MTU size is set to 1500 - monitor CPU usage during backups
(4) as for TSM TCPIP settings, TCPWINDOWSIZE (both on the TSM Server and for
TSM API set to 128KB and TCPBUFFSIZE (client, dsm.sys) set to 32KB should be
close to perfect
(5) increase TXNBYTELIMIT (this is BA/API option, mine is set to 100MB, you
might consider increasing it even more)
(6) utilize TSM capability to write to 'null device class' (there is a brief
info about this on ITSM support page) to identify bottlenecks
We were able to achieve 36MB/s throughput per stream backing up to IBM LTO 1
(though we backup DB2, not Oracle, but it does not matter here).
Regards,
Sergey
-Original Message-
From: David Nicholson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 10:27 AM
To: [EMAIL PROTECTED]
Subject: Need to optimize LARGE Oracle DB backup
Hi List,
I have a 700GB Oracle DB to backup every day. It's a 4.3 AIX
box...s LAN Free not an option for my TSM 5.2.2 server. I have
dedicated GB nic's on both the TSM client and TSM server. The network
between them is not over utilized. I am backing up directly to FC LTO II
drives. Can anyone give me some strategy suggestions on how to get this
backed up as quickly as possible. Suggestions for performing multiple
thread backups or maybe some TCPIP client options that can be tuned or
anything else you could suggest would be greatly appreciated.
Thanks in advance!
Dave Nicholson
Whirlpool Corporation
