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  What’s New with DB2?  Why Oracle Customers are Moving to DB2  Coming Attractions and Next Steps

3 Takeaways:  One aspect of DB2 that will help your organization be successful  How to get questions answered and where to go for help  A planned next step

The Mid-Atlantic Virtual Users Group • IBM Information Management • No travel! • Product information and education

The Fillmore Group • Kim May, IBM Champion • Technical Support and Consulting/Lab Services, GBS • IBM Authorized Training Partner • IBM Information Management Software Reseller

All about Bill Kincaid  What Bill does  IBM Competitive Team

Information Management 2013 IBM Information Management  DB2  Appliances – Netezza & PureSystems  Governance  Integration  Big Data  Analytics/Cognos

What’s the latest on DB2?  Functionality  Packaging options  Integration with PureSystems

Poll Question #1 IBM Information Management

DB2 Versions  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

DB2 is the highest value database in the market. DB2 has one of the lowest people cost requirements. 1. 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 DB2 is the smartest database in the market. 2. 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). DB2 reduces storage costs better than any other vendor. 3. “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. DB2 is the fastest database. 4. DB2 at largest SAP/Oracle customer in Germany  DB2 up to 9 times faster  DB2 on average over 40% faster  DB2 has the highest availability. 5. "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 DB2 is the most scalable database. 6. 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) 11

Poll Question #2 IBM Information Management

DB2 10.1 Advanced Editions Offer a Broad Solution Platform  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

DB2 ESE -> DB2 AESE V10 Key Benefits  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 Less than 3 Year Benefit DB2 AESE Upgrade Benefit Summary $9,000,000 ONE Year $8,000,000 $7,000,000 Return! $6,000,000 Cumulative Benefits $5,000,000 $4,000,000 Cumulative Investment $3,000,000 $2,000,000 $1,000,000 $0 Initial Year 1 Year 2 Year 3

Storage Optimization Feature (SOF) Compression Row Compression Adaptive Row Compression Value Compression XML Compression Index Compression Backup Compression Temporary Table Compression 30% to 70% storage reduction!

Performance Optimization Feature (POF) 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

Performance Optimization Feature (POF) Extended Insight extends monitoring beyond just the database server to understand the components of application response time across multi-tiered application stacks.

Poll Question #3 IBM Information Management

Federation and Replication 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.

Detailed Information - DB2 LUW AESE 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 Implementation Services – typically 5 to 15 days  Assistance with DB2 AESE new feature and function implementation services  Assistance compression implementation  Installation and configuration of InfoSphere Optim Performance Manager (OPM)  Installation and configuration of InfoSphere Optim Query Workload Tuner to complement OPM  Consulting on how to set-up and customize the dashboard to detect environment problems, specific database and/or application issues  Mentoring on how to monitor your systems effectively to meet your SLA’s

Poll Question #4 IBM Information Management

On the horizon  What’s next for DB2?  Interested in being a DB2 beta site?  Curious? Contact us soon!!!

Coming 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 oday, there are exciting opportunities to take advantage of all data — 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

IBM PureSystems How much flexibility, integration and workload optimization do you require out of the box? When you want When you want When you want pre-integrated pre-integrated pre-integrated and optimized and optimized data and optimized application platform infrastructure platform with flexibility Delivers high Built on IBM performance data Run your choice middleware services to of applications to accelerate transactional and and middleware deployment of your analytics which you have choice of applications to install applications Infrastructure Data Platform Application Platform