Mid Atlantic Virtual Users Group
What Your IBM Competitive Sales Specialist Wants You to Know
Mid Atlantic Virtual Users Group What Your IBM Competitive Sales - - PowerPoint PPT Presentation
Mid Atlantic Virtual Users Group What Your IBM Competitive Sales Specialist Wants You to Know Agenda : Introduction to the Mid-Atlantic Virtual Users Group Bill Kincaid Introduction IBM Information Management in 2013 Whats New
What Your IBM Competitive Sales Specialist Wants You to Know
Introduction to the Mid-Atlantic Virtual Users Group Bill Kincaid Introduction IBM Information Management in 2013 What’s New with DB2? Why Oracle Customers are Moving to DB2 Coming Attractions and Next Steps
What Bill does IBM Competitive Team
DB2 Appliances – Netezza & PureSystems Governance Integration Big Data Analytics/Cognos
Functionality Packaging options Integration with PureSystems
DB2 Express-C DB2 Express DB2 Workgroup Edition DB2 Enterprise Edition DB2 Advanced Enterprise Edition
http://www.ibm.com/developerworks/data/library/techarticle/dm-1205db2compare/sidefile.html
11
DB2 is the highest value database
1.
DB2 has one of the lowest people cost requirements.
DB2 requires 43% less DBA time vs. Oracle, Solitaire Interglobal analysis; average cost per DBA saved: $100 /hr x 40 hrs/week x 52 weeks/yr = $208,000/yr burdened. If you save 5 DBA's, That's $1M / yr
2.
DB2 is the smartest database in the market.
DB2 Autonomics; self-optimizing, self-healing, self-configuring and self-protecting, DB2 has the ability to monitor its own health status - independent of the database administrator (DBA).
3.
DB2 reduces storage costs better than any other vendor.
“With DB2 9, we’re seeing compression rates up to 83 percent on the data warehouse tables. The projected cost savings are more than US$2 million initially with ongoing savings of US$500,000 a year.” - Michael Henson, DB2 Unix Team Lead, Data-base Delivery Services, SunTrust Bank, Inc.
4.
DB2 is the fastest database.
DB2 at largest SAP/Oracle customer in Germany
DB2 up to 9 times faster
DB2 on average over 40% faster
5.
DB2 has the highest availability.
"DB2 was heavily favored in this regard... with fewer and shorter outages for normal operational activities, the overall availability and reliability of the DBMS shows some clear differentiation." — Solitaire Interglobal
6.
DB2 is the most scalable database.
DB2 pureScale reduces the risk and cost of business growth by providing unlimited capacity, continuous availability, and application transparency. Scaling your system is simply a matter of connecting a new node and issuing two simple commands. Oracle RAC scalability tails off dramatically after 4 nodes, DB2 pureScale performance stays at 95% scalability at 32 nodes, dropping only slightly as you add more nodes (81% at 112 nodes)
DB2 10.1 Advanced Editions
DB2 Advanced Enterprise Server Edition includes:
Storage Optimization Feature, including Adaptive Compression Continuous Data Ingest DB2 Workload Management, for monitoring and controlling workloads Homogeneous Replication Feature for DB2/Q Rep (restricted use) InfoSphere Federation Server (restricted between Oracle and DB2 LUW) Tooling
IBM Data Studio InfoSphere Data Architect (10 authorized users) InfoSphere Optim Configuration Manager InfoSphere Optim Performance Manager Extended Edition + Extended Insight InfoSphere Optim Query Workload Tuner InfoSphere Optim pureQuery Runtime
Performance Management Remove latent time on Application Performance for End Users Reduce downtime due to database and application performance Remove fixed costs and minimize growth by Increasing Throughput Works best for Virtualized Environment Time Savings benefits for DBAs and developers Storage Optimization Reduce Storage Costs Reduce Backup Media Costs Reduce downtime due to faster recovery of compressed data Reduce DBA time for operations such as backup, reorg, runstats
$0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 $8,000,000 $9,000,000 Initial Year 1 Year 2 Year 3
3 Year Benefit DB2 AESE Upgrade Benefit Summary
Cumulative Benefits Cumulative InvestmentLess than ONE Year Return!
Row Compression Adaptive Row Compression Value Compression XML Compression Index Compression Backup Compression Temporary Table Compression
DB2 Performance Optimization Feature gives customers the insight and ability to optimize workload execution. This feature can save money and lower risks by helping customers do more work with existing hardware, ensure Service Level Agreements (SLAs) are met or exceeded and increase DBA productivity. The Performance Optimization Feature includes three capabilities:
Optim Performance Manager Extended Edition + Extended Insight InfoSphere Optim Query Workload Tuner InfoSphere Optim pureQuery Runtime DB2 Workload Manager
Extended Insight extends monitoring beyond just the database server to understand the components of application response time across multi-tiered application stacks.
InfoSphere Federation Server (IFS) creates a consolidated view of your data to support key business processes and decisions. With Federation you can access and integrate diverse data and content sources as if they were a single resource - regardless of where the information resides. The Federation capability being included with AESE is limited to combining data from Oracle with DB2 for LUW. If you are already using IFS to combine other disparate sources such as SQL Server, Sybase and DB2 into a single virtual view, or need this capability, you must purchase the IFS software separately.
Features Detailed information on the DB2 AESE features and functions available on IBM developerWorks site: http://www.ibm.com/developerworks/data/library/techarticle/dm- 1103db2advancedenterprise/index.html Detailed Information - DB2 LUW AESE Implementation Services – typically 5 to 15 days
complement OPM
problems, specific database and/or application issues
What’s next for DB2? Interested in being a DB2 beta site? Curious? Contact us soon!!!
On April 23, see how big data can make a big difference to your business. As the world continues to see massive growth in the volume, velocity and variety of data, business and IT leaders face the challenge of harnessing this data to its full potential. Forward-thinking organizations are embracing all available data to engage customers more deeply, anticipate and resolve problems before they happen, and uncover entirely new business models. T
— including data that was once considered too ''big'' — for faster insights and agile application development, all at reduced costs. Is your organization ready? Are you able to meet accelerated business cycles efficiently, reliably, and with ease? Join us on April 23 as IBM unveils a new generation of data solutions. Register now for IBM's broadcast event: Big Data at the Speed of Business. https://engage.vevent.com/rt/ibm~big-data-management
Application Platform Data Platform
How much flexibility, integration and workload optimization do you require out of the box?
When you want pre-integrated and optimized application platform Built on IBM middleware to accelerate deployment of your choice of applications When you want pre-integrated and optimized data platform Delivers high performance data services to transactional and analytics applications
Infrastructure
When you want pre-integrated and optimized infrastructure with flexibility Run your choice
and middleware which you have to install
Optimized exclusively for transactional data workloads
Delivering data services for transactions
System for Transactions Speed
Simplicity
Scalability
configurations with no planned system downtime
Smart
change; supports DB2 applications unchanged
space savings via Adaptive Compression4
Footnotes:
Oracle Exadata No appliance-like simplicity
– HA database clusters – Multi-tenant databases – Workloads across systems
– System management – Firmware and OS updates – Live capacity upgrades
PureData for Transactions
What’s the latest from the competitive team? Customer successes Tell us why…
Afrisam saved 35% on storage by consolidating their Oracle database on HP to IBM hardware and software Borçelik cut software licensing and maintenance costs by 25% and storage requirements by 40%, by moving their SAP applications to IBM BJC HealthCare and Pep Boys moved from Sybase ASE to IBM DB2 with virtually no changes to their applications
Customers switched to IBM in the last 4 years
Successful migration factory consolidations and migrations
Compression Data Protection Data Partitioning Performance Management Developer Tooling Data Replication
Included
Includes:
database
number
Source: COST based on publicly avail U.S. info on 2/10/2011 for IBM DB2 Advanced Enterprise Edition + Oracle software w/comparable capabilities. IBM: 100 Processor Value Units. Oracle: assumes 1.0 processor multiplier. Both incl.Y1 maint/support
Added Value in DB2 Advanced Enterprise Edition
$0 $20,000 $40,000 $60,000 $80,000 $100,000 $120,000 $140,000 $160,000 $180,000 $200,000 DB2 AESE 10.0 Oracle 11gR2
Oracle Compression - $14,030 Oracle Label Security - $14,030 Oracle Partitioning - $14,030 Oracle Lifecycle Mgmt - $14,640 Oracle Golden Gate - $21,350 Oracle Enterprise Edition - $57,950 Oracle Spatial - $21,350 Oracle Internet Dev Suite - $7,076 Oracle Diagnostics - $6,100 Oracle Tuning - $6,100 TopLink Workbench - $7,076
Comparable function included
DB2 AESE 10.0
Database
and Features
Cost
DB2 AESE vs Comparable Oracle Stack Per Core Price Comparison *
* Based on publically available US $ list prices as of March 15, 2012 including year 1 S&S. DB2 AESE price assumes 100 PVU / core. Oracle price assumes 1.0 multiplier and is calculated by summing the separately purchasable packages and features highlighted on this chart.
$183,732 $54,800
“Before we made a final decision we benchmarked some of the key database management systems. That includes Oracle, SQL Server and DB2. 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
“DB2 offers massively improved functionalities when compared to Oracle, and helps to reduce database administrative workload by around 30%.”
After enabling STMM, … Reports that took 2-3 minutes to extract are now being extracted in less than 10 seconds. I have just received a call from my client asking me what kind of magic have we done. The system has almost near real-time responses with simpler queries, and 5 to 10 times faster on more complex reports (depending on the case)."- Michael Henson, DB Delivery
Services
This customer shared their migration story at the IBM Information On
Demand Conference in Las Vegas on October 24th, 2011.
DB2 now powers their primary customer website with over 50 Million
registered users and up to 1 Million simultaneous connected users per hour.
Almost 50% of the company’s transactional volume flows through this site. First databases were migrated and in production in 6 months
The largest databases went into production 3 months later. Final remaining databases moved into production in October 2011
DB2 HADR and Q Replication provide continuous availability and disaster recovery across 3 sites separated by hundreds of miles
Detailed business case showed more than $10M in savings over 4 years.
DB2 SW and HW investment payback in 24 months. Business case considered depreciation costs and tax impacts to all investment
alternatives.
8 databases supporting the full suite of applications for the customer
website were all migrated to DB2 using the Oracle Compatibility Feature.
Profiles
Credit cards
Bill payment
Over 90,000 lines of Oracle PL/SQL Stored Procedure code is now
running on DB2.
Oracle Quarter Rack Exadata vs. Small pureScale Application System
Oracle Exadata: Quarter Rack IBM pureScale Application System: Small
3 Yr TCO Savings with IBM over Oracle = 71% Investment Cost Savings with IBM over Oracle = 70%
Initial Purchase Cost Comparison
Oracle Exadata: Quarter Rack IBM pureScale Application System: Small
Savings with IBM pureScale $1,666,447 or 70%
$3.0 $2.5 $2.0 $1.5 $1.0 $0.5 $0.0 Millions
What’s motivating the change? Business
MEET Tool Migration process Follow-up
IBM contacts and resources IBM Business Partners DB2 Community
International DB2 Users Group (idug.org) developerWorks
Next Mid-Atlantic IM
DB2 101 Lunch and Learn at Baltimore’s Cinghiale
wrkincai@us.ibm.com
kim.may@thefillmoregroup.com