© 2009 IBM Corporation Break Free with IBM DB2 9.7 Reduce Operational Costs.

Author: Eugene Phelps

0 downloads 2 Views

2 © 2009 IBM Corporation Legal Notices The information on features in development is intended to outline our general product direction and it should not be relied on in making a purchase decision. The information on the features in development is for informational purposes only and may not be incorporated into any contract. The information on the features in development is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described in our products remains at our sole discretion. The information contained in this presentation is provided for informational purposes only. Although efforts were made to verify the completeness and accuracy of the information contained in this presentation, it is provided "as is", without warranty of any kind, express or implied. In addition, this information is based on IBM’S current product plans and strategy and represent IBM'S goals and objectives only, and are subject to change or withdrawal by IBM without notice. IBM shall not be responsible for any damages arising out of the use of, or otherwise related to, this presentation or any other documentation. Nothing contained in this presentation is intended to, or shall have the effect of creating any warranty or representation from IBM (or its affiliates or their suppliers and/or licensors); or altering the terms and conditions of the applicable license agreement governing the use of IBM software.

3 © 2009 IBM Corporation IBM DB2 Reduce Operational Costs Reliability Strong heritage of proven reliability, availability, and security. Low Operational Costs Automate DBA tasks, optimize storage, leading performance. Ease of Use Developer support, XML data management, virtual appliances. “We ended up choosing DB2 for several reasons. One was reliability, second was performance and perhaps the most important factor was ease of use” – Bashir Khan, Director of Data Management and Business Intelligence

4 © 2009 IBM Corporation 1. Low Operational Costs Unparalleled Automation Deep Compression Industry-leading performance Fast & easy virtual appliances  Lower administration costs  Lower server costs  Lower storage costs  Lower IT costs

5 © 2009 IBM Corporation Source: IBM Corporate Strategy analysis of IDC data, Sept. 2007 $0 B $50 B $100 B $150 B $200 B $250 B $300 B 1996‘972010‘98‘99‘00‘01‘02‘03‘04‘05‘06‘07‘08‘09 New Server Spending Server Management and Admin Costs Power and Cooling Costs Global Annual IT Spending Estimated 1996-2010 Administration is the Largest Cost 1. Costs

6 © 2009 IBM Corporation Lower Costs with Smart Administration Automatic features: DBA-free statistics collection DBA-free health monitoring And more This means that DBA shifts to: Focus on higher-value projects Respond quickly to new needs Deliver new capabilities faster It’s hard to believe, but we only have 3 DBAs supporting over 100 instances of DB2.” —Phil Kilgore, Director of Technical Services 1. Costs

7 © 2009 IBM Corporation Let DB2 Tune Itself, Focus on Your Business Self Tuning Memory Manager Configures DB2 without needing a DBA Get your system running quickly in minutes with little skills or training Let DB2 tune itself – Focus on your business, not database management Easy configuration Configuration Assistant Automatic Storage Wizards and advisors 1. Costs

8 © 2009 IBM Corporation SunTrust Saves $2M with Compression 1.5 Times Better 3.3 Times Better 2.0 Times Better 8.7 Times Better DB2 9 Other “We're seeing compression rates up to 83% on the data warehouse tables. The projected cost savings are more than $2million initially with ongoing savings of $500,000 a year“ —Michael Henson, SunTrust Bank, Inc. Lower storage costs Save 30% on storage costs compared to Oracle Database Improve performance Increase buffer pool hit ratios and decrease I/O Speed backup and recovery Less storage means faster backup and recovery 1. Costs

9 © 2009 IBM Corporation Improving the Best Compression in the Industry New Multiple algorithms for automatic index compression Unique in the industry Table Order By Temp Table Temp Intelligent compression of large objects and XML Automatic compression for temporary tables 1. Costs

10 © 2009 IBM Corporation Proven Performance Maximizes your Investments 65% Faster than Oracle Database 5X Faster than SQL Server Lower server costs for BI systems DB2 powers InfoSphere Warehouse “In comparison tests with both Oracle Database and Microsoft SQL Server, IBM DB2 continually demonstrated a better price-to-performance ratio.” —Benjamin Simmen, Zurich Financial Services 50% Faster than Oracle Database 5X Faster than SQL Server Lower server costs for transactional systems solidDB available for extreme speed Lower server costs  Lower software license costs  Lower software maintenance costs 1. Costs

11 © 2009 IBM Corporation Most Flexible Virtualization License Costs  Virtualization provides: – Reduced IT complexity – Improved IT productivity – Improved server utilization and control – Instant High Availability and Scalability  DB2 provides: – Most flexible virtualization license costs – Simplified server configuration and deployment – Best practices for AIX and VMware 1. Costs

13 © 2009 IBM Corporation Reduce Risk with Improved Security and Audit Features Understand risks and security issues Auditing redesigned for fast performance Easily find out Who, What, Where, When, and How you may have a breach Reduce risk of unauthorized access Precise Control Encryption Label-Based Access Control (LBAC)  44% of IT staff cited authorized access as key security challenge  Top challenge for 43% of CFOs is governance, controls, and risk management “IBM is a definite leader in heterogeneous data integration...” —Naomi Rafael, Melbourne Health 2. Reliable

14 © 2009 IBM Corporation Security the Way you Want It New Security has been redesigned for the complexities of having local, remote and outsourced IT staff Customize all of DB2’s security groups to your needs Fine grain control of what is part of each security level Create new security or access groups to match your company’s needs 2. Reliable

15 © 2009 IBM Corporation Robust Operation with High Availability Ultra-fast (seconds) Manage planned and unplanned outages Easy to add No rewrite of your application No specialized hardware Setup in only minutes with graphical wizard Systems can be in different locations “One of the major advantages of DB2 is that we get a disaster recovery solution for our SAP system with HADR at no extra cost.” —Gustav Elias, Austrian Railways Keep Servers Synchronized StandbyPrimary 2. Reliable

16 © 2009 IBM Corporation Meet Your Service Level Agreements Optimize Performance with Workload Management Create controls ahead of time Override them on the fly Adjust to changing priorities throughout the day Lower your costs by automating resource allocation and utilization Control for both applications and users Establish controls based on business priority Workload management Part of database engine Request management Resource management 2. Reliable

17 © 2009 IBM Corporation  Easier database changes 3. Ease of Use Database changes without downtime Industry-leading pureXML storage Integrated data management Extensive developer support  Easier XML projects  Easier collaboration  Easier development projects

18 © 2009 IBM Corporation Respond to Changing Business Needs To be successful, organizations must adapt to changing business needs Often technology and databases limit an organization’s ability to be responsive DB2 gets rid of these limits Break free with DB2: Change database schemas without downtime Move database schemas efficiently Move data to new tables without downtime Re-organize database partitions And more New 3. Ease of Use

19 © 2009 IBM Corporation Change Schemas without Downtime Respond to evolving business needs Easily update the database schema Avoid costly database downtime Make changes in real time Freely change columns used in views and other objects New 3. Ease of Use

20 © 2009 IBM Corporation Move Data without Downtime New Easily and quickly move data between QA, test, and production environments Efficiently move schema Easy to set up multiple test environments New table space can have different properties No downtime—keep tables online Extract DDL and other dependent objects Directly reference containers of table space in target database 3. Ease of Use

21 © 2009 IBM Corporation Faster “Roll In” and “Roll Out” of Data New Easily reorganize partitions based on evolving business needs Quickly detach unwanted partitions for fast data archiving and clean-up Faster “Roll In” and “Roll Out” of data Allowing you to easily: Roll in and roll out partitions based on new months as needed Easily update territory breakdowns 3. Ease of Use

22 © 2009 IBM Corporation Industry-Leading Transactional Performance for XML Data Easy development and integration No complex relational schemas No parsing upon retrieval Efficient storage Only 440GB of storage for 1TB XML benchmark Untouchable performance 6,763 transactions per second for 1TB XML benchmark DB2 “With [DB2’s] ability to process pureXML, our customers are seeing 5 to 10 times performance improvements.” —Keith Feingold, CEO, Skytide 3. Ease of Use

23 © 2009 IBM Corporation Easily Work with XML Data in your Warehouse Unlock the business insight in XML data Fast performance of analytic workloads for XML data Easily work with XML data in your warehouse XML in data partitions, range partitions, database views, and multi-dimensional clustering Improved index and compression support for XML data New “The new release of DB2 is outstanding for its data warehousing functionality...” —Jean-Marc Blaise, Venedim “The parallelization of queries and inserts of the XML data will allow our researchers to gain access to the data they require even faster...” —Tom Holdener, BJC HealthCare 3. Ease of Use

24 © 2009 IBM Corporation Increase Collaboration with Integrated Tools Integrated data management tools IBM InfoSphere Data Architect*, IBM Data Studio, IBM Optim solutions, IBM InfoSphere Mashup Hub All phases of data lifecycle Collaboration across roles Business analyst, database architect, DBA, application developer, etc. Support all major database platforms IBM DB2, IBM Informix, Oracle Database, Microsoft SQL Server, etc. “Our development will operate up to 20% to 50% faster than before.” —Janick Bernet, Developer, Swiss ASP Develop Design Deploy Optimize Operate ModelsPoliciesMetadata * Formerly Rational Data Architect 3. Ease of Use

25 © 2009 IBM Corporation Faster and Easier Development Projects Easy application development and deployment Support for all the latest languages and versions Support for all the latest environments, including Visual Studio 2008, Eclipse, and pureQuery Support for multiple SQL dialects and procedural languages Accelerate development with custom and built-in packages Easy Web services Choice of query languages and APIs SQL, XQuery, XPath, CLPPlus, JDBC, SQLJ, ODBC, ADO,.NET, CLI, OLE-DB, and more Univar increased developer productivity by 25-50%. They reduced development costs by 35-45%. New 3. Ease of Use

26 © 2009 IBM Corporation Concurrency Models to Fit Your Needs Support multiple “concurrent access” models, allowing you to… Optimize throughput for mixed workloads Eliminate conflicts between Read and Write workloads Easy for developers to work with DB2 Log-based control No management overhead No performance overhead Much simpler than Oracle Database rollback segments New 3. Ease of Use

27 © 2009 IBM Corporation Flexible Data Typing New Traditionally, DB2 has supported strict typing: In accordance with SQL standard Trend towards weak typing in programming: For PERL, RUBY, PHP, etc. DB2 now supports: Easy casting between data types Great performance with or without parameter markers Easy for your application to use DB2 Easy for your developers to use DB2 For instance, no changes for applications with Oracle Database “DATE” 3. Ease of Use

28 © 2009 IBM Corporation IBM DB2 Lower IT Cost Made Easy “DB2 beats everything hands down in terms of costs, reliability, and ease of use.” —Jochen Guther, Managing Director Reliability Strong heritage of proven reliability, availability, and security. Low Operational Costs Automate DBA tasks, optimize storage, leading performance. Ease of Use Developer support, XML data management, virtual appliances.

31 © 2009 IBM Corporation Top Performance for SAP DB2 is Optimized for SAP Average 40% better performance World record SAP benchmark, outperforming Oracle Database by 18% and needing only half the processing power! Lower Cost with DB2 Average 40% Storage Savings Average 25% DBA Labor Savings 33% Growth in SAP clients choosing DB2 since 2006 >100 clients migrated from Oracle to IBM in past 12 months “We expected an improvement of around 20% in terms of system response time, but we found that the new system was actually 40% faster. The DB2 database is even more efficient than we anticipated.” —Peter Boegler, SAP

32 © 2009 IBM Corporation Strong Platform and Operating System Support Enjoy platform flexibility to meet your current and future needs Support for the following hardware platforms and operating systems: 32-bit and 64-bit Windows Red Hat Enterprise Linux (RHEL) 4 and 5 SUSE Linux Enterprise Server (SLES) 9 and 10 Linux on System x™, Linux on System z™ Linux on IBM Power Systems (i Series and p Series) AIX 5L™ V5.3 HP-UX 11i v2 and v3 on Itanium Solaris 9 and 10 on UltraSPARC Mac OS X (Beta on Express-C only) Optimized for virtual environments and the cloud Easy to configure for multi-tenancy

© 2009 IBM Corporation Break Free with IBM DB2 9.7 Reduce Operational Costs.

Recommend Documents