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:wboyer AT PTD DOT NET]
> Sent: Monday, June 11, 2001 2:29 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> 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!" - ???
>