1 / 54

The Value of DB2 Optimized for SAP

The Value of DB2 Optimized for SAP. Agenda. IBM/SAP Partnership Unique DB2 Features for SAP DB2/SAP Performance Migration to DB2 DB2/SAP Customer Experience Next Steps. DB2 Value to SAP Customers. The Value Stack. The Technology which creates value. Total value to your organization.

laraine-ulysses
Télécharger la présentation

The Value of DB2 Optimized for SAP

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The Value of DB2 Optimized for SAP

  2. Agenda • IBM/SAP Partnership • Unique DB2 Features for SAP • DB2/SAP Performance • Migration to DB2 • DB2/SAP Customer Experience • Next Steps

  3. DB2 Value to SAP Customers The Value Stack The Technology which creates value Total value to your organization • DB2 tops SAP Certified Benchmarks • Compression reduces network traffic • Database Partitioning gives unlimited scaling • Multi-Dimensional Clustering vastly increases ad-hoc query performance Optimize Performance • Data Cockpit reduces DBA time by 25% • Integrated backup/recovery plus HADR increases availability • SAP OSS provides one-stop support Operational Excellence • Compression reduces storage footprint by 40% • Lower server infrastructure cost • Avoid unnecessary upgrades • Complete out-of-the-box solution Reduce Cost

  4. SAPDB2 Product Integration SAP on DB2 is a fully integrated product • SAP installation integrates • DB2 install • HA setup • One-step, SAP-tailored DB2 configuration(DB2_Workload = SAP) • SAP DBACOCKPIT integrates DB2 admin/monitoring • Near-concurrent GA certification • For DB2 releases and fix packs One-stop support offering • SAP provides single-point-of-contact to customers • Joint support staffed with SAP and IBM engineers Aligned maintenance cycles • IBM DB2 follows SAP’s 7+2 maintenance strategy

  5. Integrated Roadmap: High-level Planning 2010 DB2 2009 2009 3Q/09 NW 7.0 EhP 2 • Integrated Nearline Storage • Top-Down, Revamped Monitoring • Time based analysis • Drill down along multiple dimension • Drill down into history • Improve End-To-End Solution Support • MDC Advisory Stage 2 • LONGLOB transition 2H/2009 „Cobra“ Full 360° Monitoring Even Deeper Deep Compression • 40+% reduction in Indexes/Temps • Inlined LOBs Near-0 Storage Admin • Sparse MDC simple space reclaim • Easy table space reclamation • Ease the path to Automatic Storage Extending Online Operations • Change schema definitions online • Reorganization improvements Extend Integrated HA+DR OS coverage Additional BI query performance boosts 2008 2008 2Q/08 NW 7.0 SR3 3Q/08 NW 7.0 EhP 1 Turn-key HA solution Performance/TCO differentiators (MDC) Turn-key compression Performance Warehouse Integrated Workload Management Integrated MDC advisor Deferred Table Creation 2008 Version 9.5 Integrated & automatic HADR Integrated Flash Copy TCO improvements • DPF • Memory Management • Statistics Management • Compression Performance improvements (MDC) Threaded Architecture DPF Scaling Improvements 2007 2007 1Q/07 NW 7.0 Embedded database Unlimited scalability Minimal admin TCO (reduced storage costs, self tuning) 2007 Version 9.1 Storage limits removed Near-0 admin • Memory • Storage Selected Autonomic / TCO features Compression 2006 2005/6 2Q/05 NW 2004 Streamlined install Streamlined admin Initial BI MDC exploited Auto storage EE 2005/6 Version 8.2.2 Automatic storage admin Deployment optimized for SAP Tailored concurrency & performance improvements 2005

  6. Strategic Technology Alignment VERSION RELEASE LATENCY 2.5 years VERSION RELEASE LATENCY 4-8 weeks

  7. Database Quality Patches per month* 2.27 • Fewer patches • Less downtime • Less administration time • Lowers TCO for DB2 SQL Server 2005 1.97 OracleV10.2 • *In 2.5 to 3+ years up to September 2009 • DB2 V9: 11 patches over 38 months • Oracle V10.2: 67 patches over 34 months • SQL Server 2005: 68 patches over 30 months 0.29 DB2V9

  8. SAP is a very satisfied DB2 customer SAP IT adopted DB2 in early 2000 • Uses DB2 for SAP’s R&D and business systems • Runs DB2 on 1200 systems (as of October 2008) Research and Development • Major SAP products use DB2 for development and/or QA • ERP, BI, CRM, SRM • DB2 is a major R&D platform at SAP Business systems • SAP has migrated its major internal business systems to DB2 • HR, ERP, CRM, BI – all run on DB2 Feedback from SAP IT:Consistently extremely good experiences with DB2 quality and performance

  9. SAP on DB2: Key Technology Differentiators Selected differentiators covered: • DB2_WORKLOAD=SAP • DB2 Compression • SAP on DB2 virtual tables • DB2 Integrated HA • DB2 Database Partitioning Feature • DB2 Multidimensional Clustering • DB2 Automatic Maintenance • Online Table Reorg • DBACockpit • DB2 Workload Management • DB2 in SAP‘s Database Performance Warehouse • SAP NetWeaver BW Nearline Storage on DB2 This is not an exhaustive list and only intended to provide an overview. You can find more information about SAP on DB2 in SDN.

  10. DB2 Deep Compression reduces storage cost • The facts • DB2 compression technology is unique • Reduces table size by 70%-85% • Transparent to the application • Fully supports SAP • Releases from R/3 to 3.1l up to newest • The benefits • Reduces storage cost 55% - 68% • Cost per managed TB ~ $50K/year • Reduced I/O requirements and better CPU utilization • Better memory utilization – virtual increase of 40% • Better performance and reduced backup/restore time

  11. Storage savings with DB2 compression 8.0TB 2.5TB 660GB 8.5TB 176 1200GB 651GB 420GB 1061GB 266 950GB 545GB 575GB 92 1.4TB 377GB 372GB 3.7TB 380GB 151 230GB 4.5TB 10TB $250K/year saved 5TB * Includes Unicode conversion ** Based on $50K per year to manage 1 TB

  12. DB2 Data compression benefits Key resource utilization slashed • Processor load up to 60% • Input/output traffic up to 70% • Memory usage up to 40% • Compression is on external storage and in memory 20% CPU utilization for DB 15% 10% 5% 0 Week Feb 1 Week Feb 8 Week Feb 15 Week Feb 22 2009 Better backup • Reduced size and time • Size reduced up to 85% • Time reduced up to 65% • Better batch performance • Up to 10x faster Compression key 1200 Reads+writes per second Before After 1000 800 600 400 200 0 Week Feb 1 Week Feb 8 Week Feb 15 Week Feb 22 2009

  13. Unicode overhead? DB2 compression to the rescue! 70+% 60+% 950GB 575GB 60% 30% 50% 40% 70%

  14. Business Intelligence: Warehouse size Disk space used • SAP Business Warehouse 3.1 on: • Oracle 10.2.04 • DB2 9.7 1,991GB 1,847GB Oracle uncompressed Oracle compressed 878GB 824GB DB2 compressed DB2 compressed 58.6% saving 52.5% saving Later comparison More data loaded into warehouse Oracle data compression used Initial comparison

  15. Business Intelligence: User productivity Oracle DB2 96.7 2.2 121.3 5.2 346.4 47.9 127.6 6.7 74.2 31.2 32.6 25.1 114.1 14.9 22.0 2.4

  16. Business Intelligence: User productivity Oracle DB2 119.6 4.3 41.4 67.4 24.1 25.4 13.5 5.1

  17. Business Intelligence: Load efficiency Oracle DB2 36.2 47.0 201.3 228.5 197.7 174.9 84’ 40” 37’ 22” During data load DB2 is doing the compression “heavy lifting”. Despite this: • Data load times are comparable • Even better in many cases!

  18. Business Intelligence: Impact on network Input/output activity to execute a multi-user query 1,000 Queries were carried out in series. Superimposed here for comparison. Total Mbytes read 800 440.1 Oracle 600 KB/sec DB2 400 200 16.3 Data is compressed: • On disk – saves disk • In cache – increases cache hit rate • In memory – increases amount of database resident Lower-cost BI queries  More BI queries  More business value

  19. Business Intelligence: Scaling DB2 Database Partitioning Feature: • Database spread over many processing “units” • Processing “units” share nothing • Total capacity scales linearly With DB2 DPF Traditional Total BI power delivered Status of DB2 DPF: • Mature technology: Supported since SAP BW 2.0 • Almost universally adopted by SAP BI installations Total server power deployed Benefits of DB2 DPF: • Better utilization of all forms of servers, including: • High-end SMP servers • Multiple, low-cost servers • Lower cost plus easy growth Lower-cost BI + easy growth  More BI usage  More business value

  20. Business Intelligence: Nestle case study Requirement Attained with DB2 8 hrs 2hr 40min 24 hrs 10 hrs 12 hrs 6hr 10min 8 hrs 30 min Solution Stack • Software • SAP NetWeaver 7.0 • IBM DB2 V9 • Tivoli Storage Manager • Hardware • IBM p595 with AIX 5.3 • IBM DS8300 Turbo • IBM 3584 Table Library

  21. High Availability and Disaster Recovery Integrated into SAP DB2 HADR • Features • Near-sync standby • Rolling updates • Cluster manager • Business benefits • Increased availability • Rapid disaster recovery Fully supported for all SAP releases Integrated into SAP installation No extra cost!

  22. DB2 Migration at Austrian Railways Goal SAP infrastructure cost reduction and simplification • Why IBM DB2 • Lower license cost • SAP Certified HADR solution out of the box 30% lower 50% lower 70% lower 97% lower 25% lower

  23. Smart Maintenance Integrated into SAP DBACOCKPIT DB2 automates most DBA activities • Memory tuning and configuration • Storage and log file management • Collection of table and index statistics • Many more … Fully supported for all SAP releases Integrated into SAP installation No extra cost!

  24. DBA Cockpit Single SAP admin interface • From one GUI access: • SAP and DB2 • Multiple systems (remote admin) • Integrated into: • SAP shipping system • SAP installation • Benefits include: • Admin productivity • Usability • Better DB2 remote admin • No external tools needed Access to multiple systems/partitions Performance monitoring Space management Backup and logging DB and instance configuration Job scheduling DB monitoring and diagnostics

  25. Online Reorganization DB2 online table reorg – Managed from DBA Cockpit DB2 benefitSAP and DB system remain online!All the time!!

  26. Workload Management (WLM) Integrated into SAP DBA Cockpitand SAP Solution Manager DB2 Workload Manager • Prioritize and control DB2 workload by: • SAP process types (dialog, batch, spool,…) • End user names • Application server groups Fully supported for all SAP releases Integrated into SAP installation No extra cost!

  27. Database Performance Warehouse Index hit % Total hit % Data hit % Integrated into SAP Solution Manager DB2 Performance Warehouse • Collection of historical performance data. • I/O behavior, response times, wait times, … • Flexible data analysis with drill-down reports • Predefined and user-defined Fully supported for all SAP releases Integrated into SAP installation No extra cost!

  28. SAP NetWeaver BW Nearline Storage Integrated into SAP Nearline Storage on DB2 • Offloads infrequently used data from SAP BW • Reduces size and load of production BW • Fully exploits DB2’s compression • Utilizes DB2’s powerful self-management Fully supported for all SAP NetWeaver releases Integrated into SAP installation, admin, monitoring No extra cost!

  29. DB2 Superior Performance 3-tier Banking15,519,000 account postings per hour 3-tier Sales and Distribution168,300 users: 1.95 second response time 3-tier BI Warehouse311,004 query navigation steps per hour DB2 outperforms Oracle in all customer POCs

  30. SAP/DB2 Retail and CPG Customers

  31. Major Organizations Moving to DB2 – 100% Success, 100% Migration Samsung, Korea Allianz, Germany Dansk Supermarket, Denmark Gieseke&Devrient, Germany Karstadt Itellium, Germany INA Schaeffler, Germany Modello, Mexico Austrian Railroad, Austria Mahle, Germany Telmex, Mexico Tellabs, US Orica, Australia Ducati, Italy Baywa, Germany Shoprite Checkers, South Africa Eurovia, France Super De Boer, Netherlands IDS Scheer Mainova, Germany Coca Cola, US Colgate, US Eli Lilly, US Fiat, Italy Barilla, Italy Ciba, Switzerland Pacific Corp, US SONY, Japan Ericsson, Sweden Pilkington, Germany Faurecia, France LSI, US Stada, Germany Australian Wheat Board Netcare, South Africa AnSteel, China Pioneer Foods, South Africa Carlsberg Breweries, Denmark Over 100 organizations have migrated SAP to DB2

  32. Advantages of DB2 OEM Licensing via SAP DB2 Bundled with Application being Sold by SAP • Restricted Use license for SAP only, supplied by SAP DB2 License is priced as Percentage of SAP Net Application Value • DB2 annual maintenance is priced as % of DB2 license New DB2 base features packaged by SAP as part of the OEM license are delivered via SAP maintenance agreement at no extra charge All DB2 Maintenance Updates and Support thru SAP • One Stop Service and Support via SAP OSS • DB2/OEM aligned with SAP “7+2“ Maintenance cycle • No forced database or application upgrades

  33. DB2 OEM license from SAP Licensing Details: • Unlimited use of DB2 for SAP applications • Features Included • Database Partitioning • Multi-Dimensional Clustering • High Availability Failover for Disaster Recovery ( HADR ) • Compression ( Data and Index Compression ) • Workload Management • No Additional License and Maintenance Charges for Y/Y DB Growth • Nearline Storage • Performance Warehouse

  34. SAP is better with DB2 – By Design Thank you. Questions?

  35. Backup and detail slides Main line These slides are intended to be used in sequence. (Originally there was approximately 40 slides in this section) When you hover over some objects on a main-line slide the cursor turns into a pointing finger. This indicates that this object hyperlinks to a detail slide. Clicking on this object will jump to the detail slide. Separator When reorganizing slides and adding new ones, it is wise to think carefully about this structure! The “Thank you” slide stops you from inadvertently crashing into the detail slides Detail/backup These slides are intended to be used by clicking on links in the main line slides. Each slide has a return arrow to take you back to where you left the main line. The top right-hand corner of each detail slide shows a return arrow. Clicking on this arrow takes you back to the main-line slide – back to where you came from.

  36. SAPDB2 Product IntegrationDetail: Integrated Installation Return

  37. SAPDB2 Product IntegrationDetail: Integrated DB2 admin/monitoring Return

  38. Integrated Roadmap: Detail 2008 Return 2010 2009 2008 2008 2Q/08 NW 7.0 SR3 3Q/08 NW 7.0 EhP 1 Turn-key HA solution Performance/TCO differentiators (MDC) Turn-key compression Performance Warehouse Integrated Workload Management Integrated MDC advisor Deferred Table Creation 2008 Version 9.5 Integrated & automatic HADR Integrated Flash Copy TCO improvements • DPF • Memory Management • Statistics Management • Compression Performance improvements (MDC) Threaded Architecture DPF Scaling Improvements 2007 2006 2005

  39. Integrated Roadmap: Detail 2007 Return 2010 2009 2008 2007 2007 1Q/07 NW 7.0 Embedded database Unlimited scalability Minimal admin TCO (reduced storage costs, self tuning) 2007 Version 9.1 Storage limits removed Near-0 admin • Memory • Storage Selected Autonomic / TCO features Compression 2006 2005

  40. Integrated Roadmap: Detail 2005/6 Return 2010 2009 2008 2007 2006 2005/6 2Q/05 NW 2004 Streamlined install Streamlined admin Initial BI MDC exploited Auto storage EE 2005/6 Version 8.2.2 Automatic storage admin Deployment optimized for SAP Tailored concurrency & performance improvements 2005

  41. Integrated Roadmap: Detail 2010 Return 2010 2010 • Improve End-To-End Solution Support 3Q/09 NW 7.0 EhP 2 • Improve End-To-End Solution Support • Integrated Nearline Storage • Top-Down, Revamped Monitoring • Time based analysis • Drill down along multiple dimension • Drill down into history • Improve End-To-End Solution Support • MDC Advisory Stage 2 • LONGLOB transition 2010 Full 360° Monitoring Even Deeper Deep Compression • 40+% reduction in Indexes/Temps • Inlined LOBs Near-0 Storage Admin • Sparse MDC simple space reclaim • Easy table space reclamation • Ease the path to Automatic Storage Extending Online Operations • Change schema definitions online • Reorganization improvements Extend Integrated HA+DR OS coverage Additional BI query performance boosts 2009 2008 2007 2006 2005

  42. Business Intelligence: Case study detail Return Backup/restore view of the Nestle infrastructure

  43. DB2 High Availability and Disaster Recovery Return

  44. DB2 HADR Fully Integrated Return Integrated into SAP installation All releases in service No extra cost

  45. Austrian Railways rolls out lower TCO with IBM Information On Demand Return

  46. Automatic MaintenanceDetail 1: Automatic Table Statistics Return

  47. Automatic MaintenanceDetail 2: Cockpit screens Return Automatic REORG Automatic RUNSTATS Automatic Backup

  48. Workload ManagementDetail 1: DB2 workload overview Return

  49. Workload ManagementDetail 1: DB2 workload service classes Return

  50. Nearline Storage on DB2Detail 1: Architecture Return

More Related