Richard --

I do a large Oracle/SAP database nightly, with this result:

BR077I Database file for backup: /oracle/PRD/sapbackup/cntrlPRD.dbf
BR061I 487 files found for backup, total size 746281.344 MB
BKI1215I: Average transmission rate was 260.748 GB/h (74.168 MB/sec).
BKI1227I: Average compression factor was 1.00.
BKI0020I: End of program at: Thu Feb 20 21:49:52 2003 .
BKI0021I: Elapsed time: 02 h 47 min 47 sec .
BKI0024I: Return code is: 0.

My TSM server is an RS/6000 660-6M1 with 10 LTO tape drives in an IBM 3584
library. This backup does NOT go to disk, it goes directly to four tapes,
over two gigabit ethernet interfaces. The database server is another
660-6M1, with three fiber-channel connections to an IBM ESS. Both systems
are 4-way; the database server has 8 GB and the TSM server is a 6 GB system.
The tape drives are SCSI, with two drives per cable; I see about 4.5 to 1
hardware compression on this backup. The gigabit ethernets are dedicated for
backups (my 'backup1' and 'backup2' networks). The TSM database and disk
pools are spread over two ESS arrays, with the database and recovery logs
TSM mirrored between the two (yes, I'm paranoid; so?)

During the backup the TSM server runs at 30 to 40% CPU usage; the SAP
database server is at 70 to 90% (anyone got a clue why TDP/R3 would pound
the CPU like this, when it's not doing compression? I am doing 6-way
multiplexing, that may be a contributor).

Tom Kauffman
NIBCO, Inc

-----Original Message-----
From: Dearman, Richard [mailto:rdearm1 AT UIC DOT EDU]
Sent: Friday, February 21, 2003 9:34 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Anyone doing 1TB+ Backup Nightly


I do 1TB+ backups nightly which run for about 8 hours.  A large part of our
backup is a 500GB Oracle database backup to TSM.  The database backups up
over a private 1Gb connection to a AIX P660-6h1 server with 2GB of RAM and 4
processors.   The data then goes to nine 2disk stripe sets, over a 1Gb SAN
connection (I went with stripe sets because RAID5 was just to slow).  I'm
getting high iowat times on my AIX TSM server.  I'm having a hard time
pinpointing exactly where the bottleneck is at.  Currently it takes 51/2
hours to backup 500GB but I know it can be better.

My question is are any of you that are moving this amount of data faster
than me using a more powerful server like a IBM 690.

THanks
***************************EMAIL DISCLAIMER*************************** This
email and any files transmitted with it may be confidential and are intended
solely for the use of th individual or entity to whom they are addressed.
If you are not the intended recipient or the individual responsible for
delivering the e-mail to the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on it,
is strictly prohibited.  If you have received this e-mail in error, please
delete it and notify the sender or contact Health Information Management
312.996.3941.