Software im SAP Umfeld_IBM DB2
-
Upload
ibm-switzerland -
Category
Documents
-
view
593 -
download
2
Transcript of Software im SAP Umfeld_IBM DB2
Place photo here
1IBM Confidential 2012
Mehrwert von IBM Software im SAP UmfeldIBM DB2 for SAP – Performance steigern Kosten senken
Günter Schmidt
Competitive Sales Information Management
IBM Confidential 2012
TODAY DB2 is the Database Champion for SAP Customers
… if you were to come up to me and ask me would we do this again, migrate to DB2, the answer would be a clear yes. - Jim Capraro, VP GIT Colgate-Palmolive
…We are beta testing DB2 version 10 right now and the compression has gotten better again, we are going to see another 20% increase..- Tom DeJuneas, IT
Team Manager ,CCBCC
Video: Coca-Cola Bottling Co. Consolidated saves more than $1 million with IBM DB2
Video: Colgate Migration to DB2 SAP Reference Interview http://db2forsap.blogspot.com/2011/11/colgate-palmolive-reference-interview.html
http://ibmdatamag.com/2012/04/case-study-coca-cola-bottling-co-consolidated/
IBM Confidential 2012 3
DB2 V10 - Adaptive Compression: Italian Customer Test
IBM Confidential 2012 4
Ergebnisse eines PoCs bei Schweizer Kunden
27 months9 – 11 months9 – 11 monthsPayback period
> 0.6 million> 1.2 – 1.5 million> 1.2 – 1.5 millionAnnual savings
1.3 million3.9 million3.8 millionTotal savings (5 year)
2.5 days1.5 days1.5 daysTechnical Migration effort from Oracle 10
55.1%82.2%82.2%Backup Compression
55.1% (36%)75.6%72.6%Storage Compression
Oracle 11.2G (Advanced compression)
DB2 V10DB2 9.7Topic
- PoC real system copy of a productive SAP Systems on comparable hardware - Oracle Compression Algorithm shows weak storage allocation and needs a lotof CPU power, so the strongest compression algorithm is not usable in a productive setup
- Performance comparison: DB2 48% better, although Oracle needed 30% more memory- Customer decided for IBm DB2 in December
IBM Confidential 2012 5
Projektüberblick
• Lonza has decided in 2011 for IBM DB2• Seven SAP landscapes had to be migrated
(SRM, GTS, PI, HR, CRM, ERP, BW)
• Defined Goals:–Lower license costs for the database
–30% - 50% of reduced storage capacitiy
• Issues during migration:–SRM, PI, GTS, HR without Issues
–ERP & BW: Several Performance issues could be solved within a couple of days.(Custom code tuning – Select statement changes)
IBM Confidential 2012 6
Projektüberblick
Defined goals in PH
� Lower license costs
� Reduced disk space requirement (- 30% –50%)
Achievements:
� Maintenance costs can be reduced(calculated with the 11% maintenance costs of ORACLE)Oracle announced to raise the maintenance to 15% for new systems. So the difference would be even higher.
� Diskspace a reduction of 40-60% could be realized
IBM Confidential 2012 7
Project overview and feedback
� Project could be finalized as planned
– In time
– In scope
– In Budget
� Collaboration was very good
– Consultants with the Basis team
– Within Project management
– All Business Application team member who needed to solve performance issues
� Feedback
– Project was handled very professional
– End User had almost no impact
IBM Confidential 2012 8
DB2 10 Advantages for SAP ApplicationsReducing the Overall Costs (TCO)- Reduced DB storage size 40%-85%- Reduced tape capacity 50%-85%
- Reduced DB-RAM 20%-50%- Reduced log space 50%-75%- Reduced temporary space 40%-85%- Better OLTP performance 20%-30%
- Better OLAP performance 50%-75%- Recovery time objective RTO < 1min
- Recovery point objective RPO � 0- Less database license (SAP OEM) 47%
Innovative Database Technology- Leading DB performance- Adjusted development with SAP- State-of-the-art database administration –
automated, integrated- Integrated high-availability and disaster-recovery –
easy, efficient- Integrated standby database solution with time
delay - Scaleout and scale-up with one source code- OLTP and OLAP systems with one source code- Integrated NLS (near-line storage) solution- SAP BW optimization with DPF/MDC- HP-UX Itanium supported- VMWare, XEN and Hyper-V supported
Strategic Partnership with SAP and DB2- Over 1000 DB2 systems at SAP
- SAP involved in the DB2 development- Roadmap synchronized ���� line items until 2015- DB2 9.7 and DB2 10 until 2022 supported for SAP
applications- DB2 follows SAP’s „7+2“ support strategy- In 4-8 weeks available with SAP- Reduced requirement for database
upgrades/patches- Less tuning required (SAP knob)
Coca-Cola (Andrew Juarez, SAP Lead)
Compression: - DB2 9.1 with table compression reduced Oracle
database size during unicode conversion by 40%. � ~50% storage saving without unicode
- DB2 9.7 with index compression +17% saving � 67% storage saving.
- DB2 10 with adaptive compression + 20% saving � 87% storage saving
Performance- DB2 9.1 manufacturing runs are over 65% faster than
on Oracle on same server- DB2 10 performance improved in average from 30% -
60% compared to DB2 9.7. In an extreme case SAP programs go from 30+ hours down to 2 hours
IBM Confidential 2012 9