Transcript ASUG - Why DB2 for SAP

Improving TCO in Your
SAP Infrastructure
Larry Yeager
IBM North American Sales
DB2 for SAP
[email protected]
610 662 0818
© 2008 IBM Corporation and SAP AG
In the beginning…
•
SAP and Oracle were strong partners until 1999
•
•
•
Enterprise customers running Unix, deployed SAP on Oracle
Small Business clients deployed on Microsoft SQL Server
In 1999 IBM and SAP began jointly developing “DB2 Optimized
for SAP” versions
•
DB2 became SAP’s development database; all new and existing modules are
developed on DB2, then ported to other DBMS platforms
•
4 major DB2 releases since 2005 (v8.2, v9.1, v9.5, v9.7)
Follow SAP’s 7+2 software maintenance cycle
SAP certified in 8 weeks or less from public GA
Dramatically lower volume of SAP specific DB patches
•
•
Joint integration Centers in Toronto, CA and Walldorf, Germany
IBM and SAP sit side by side, planning new releases, developing a joint roadmap,
testing software, and supporting our joint customers.
2
Why DB2 for SAP?
Why Are Customers Selecting DB2 for SAP ?


Optimize
Performance


Operational
Excellence






Reduce Costs



DB2 leads in SAP Certified Benchmarks
Customers see 15%+ performance boost with DB2

Reduce network traffic with compression
For SAP BW

DPF (Database Partitioning Feature)
provides horizontal unlimited scalability

Multi-Dimensional Clustering improves
ad hoc query performance
Reduce DBA efforts by 25% with integrated DBA
Cockpit , Automated Memory / Storage Mngmt
Higher database availability through integrated
backup / recovery / restore and HADR
One stop service and support via SAP OSS
DB2 Follows SAP 7+2 Maint – No Forced Upgrades
New Versions Certified in < 8 weeks by SAP
Minimize storage footprint by 55%-68%
Lower infrastructure costs via compression,
improved performance
Avoid unnecessary upgrades
Complete out-of-the-box solution
OEM Pricing / Packaging – Not CPU / Core Driven
3
3
Why DB2 for SAP?
SAP Runs DB2, IBM Runs SAP
The Facts
IBM runs its business on SAP/DB2
SAP runs its business on SAP/DB2
SAP has migrated 1,200 internal
systems from Oracle to DB2
200+ SAP customers have migrated
to DB2 Optimized for SAP in the last
18 months
700+ new SAP customers chose DB2
over other DBMS platforms in 2010
DB2 marketshare for SAP reached an
estimated 31% in 2010 - up from 12%
in 2006
4
4
Why DB2 for SAP?
DB2/SAP Value Proposition Summary
1) #1 in performance for SAP customers:
Faster than Oracle for R/3 & ECC6
Faster than Oracle for Netweaver BW
20+%
40+%
2) Reduces TOTAL SAP Infrastructure Cost:
Reduces SAP storage needs compared to Oracle
Reduces database server requirements compared to Oracle
Reduces database license & maint cost vs. Oracle via SAP OEM
> 20%
55% - 68%
10% - 15%
28% - 70%
3) Provides the highest database availability for SAP environments:
Fully integrated, free of charge HA/DR solution for SAP via SAP OEM
4) The Strategic Database for SAP:
Faster access to leverage new database advances for SAP
Integrated development. Aligned maintenance. Service and Support.
5
Why DB2 for SAP?
2+ Years
200+ SAP customers migrated to DB2
6
6
Why DB2 for SAP?
2010 Actual Migration Customer Evaluation Findings
7
Criteria Considered
Windows DB Provider
Compression
No production systems utilizing
compression
$3k/CPU, no guarantee
Guarantee 40% savings, no
additional cost
Disaster Recovery
Partially Automated
Partially Automated
Fully Automated
Virtualization Support
Yes
No
Yes
Patches
~600 hrs / Year
~200 hrs/year
5+1+2 (follows SAP),
integrated with SAP patching
Certification Timeline past GA
12 wks avg
120 wks+ avg
5 weeks average
Number of patches (latest
release)
2; OS patching happens
monthly
55
4
DBACOCKPIT used for admin
Monitoring only
Monitoring Only
85+% admin according to
IBM
5 Year TCO % Increase for Unicode
Compliance
70%
56%
24%
Why DB2 for SAP?
Existing UNIX DB
Provider w/upgrade
IBM DB2
Presented at AFSUG, November 2010
35
60%
28.75
30
Size in TB
25
20
15
73%
11.83
13.76
11.51
10
5
48%
7.2
3.2
65%
3.16
1.11
0
SAP ECC6
BI Test
All Other
SAP Systems
8
Why DB2 for SAP?
Total
Oracle
DB2
SAP System AP6 - AHM Logistic and Production
•
Database size
•
•
•
•
•
3.6 TB before migration (Oracle)
1.5 TB after migration ( DB2)
Database size reduction between 53% and 73%
Backup time reduced from 10 hours to 2 hours
Dialog Response times
•
•
•
Key transaction response time improvement of 40%
Average response time improvment of 27%
Batch processing
•
•
Runtime in average reduced by 50%
Memory consumption of SAP Database
•
•
9
45% less DB-RAM
91% less RAM-SWAP
Why DB2 for SAP?
Recent DB2 Migration Decisions
•
Coca-Cola Bottling Company – Had no DB2 skills
•
•
•
•
•
PacifiCorp ~ Power and Utilities – Trained Oracle Basis team
•
•
•
•
•
•
10
Unicode upgrade required additional Oracle licenses - very
expensive. DB2 OEM offer by SAP reduced maintenance cost and
storage requirements by 50%
DB2 reduced the size of SAP databases by 40%
Better performance – Manufacturing batch runs are 65% faster
Reduced DBA workload to manage DB2.
Hardware refresh, ran SAP on SUN/Oracle
Evaluated HP/SQL Server, SUN/Oracle and pSeries/DB2
selected pSeries and DB2
SAP DB2 OEM Value
Compression results 60% R/3 and BW 45%
Increased performance
Reduced Administration time
Why DB2 for SAP?
German Insurance Company POC Results – Summer 2010
DB2 v9.7 vs. Oracle 11g.R2 Compression
Database Size
600
Size (GB)
500
400
65,
4%
300
45,
6%
200
36,
4%
100
0
Other Uncompressed
Other Compressed
DB2 Compressed
DB2 9.7 delivers 36.4% Storage Savings over Oracle 11g.2 Advanced
Compression which costs $11,500 per CPU (License)
11
Why DB2 for SAP?
SAP Value Engineering Business Case Modeler
Provides:
•Payback period
•3 Year ROI
•5 Year ROI
•IRR
•NPV
•Based on actual
customer
migrations
Free Service Provided by SAP Value Engineers & IBM
12
Why DB2 for SAP?
13
Why DB2 for SAP?
Americas DB2/SAP 2011 Team
[email protected]
Latin America
Cherelle Paoletti
Russ Harmon
[email protected]
(415) 545-4288
[email protected]
(512) 286-2355
14
[email protected]
(416) 478-9935
DB2 for SAP Software Sales Manager
[email protected]
(612) 397-2067
(561) 862-2291
Pacifics
Jonathan Budd
Skip Lindgren
Sandra Titarelli
Great West
Why DB2 for SAP?
Larry Yeager
[email protected]
(610) 578-2343
Great Lakes
Midwest
Federal
Canada
Tom Levy
Phil Anthony
[email protected]
(770) 866-4081
[email protected]
(781) 895-2816
Southeast
Mid-Atlantic
Northeast
NY Metro