Conor O'Mahony's Database Diary

Your source of IBM database software news (DB2, Informix, Hadoop, & more)

Archive for the ‘SAP’ Category

Coca Cola Bottling Move from Oracle Database to IBM DB2

with one comment

At the 2011 IBM Information On Demand (IOD) Conference, Coca Cola Bottling spoke about their experiences when moving from Oracle Database to IBM DB2. I have included some very brief video segments shot at the conference below. It is really interesting to heard about the experiences and impact of switching from Oracle to IBM from the people involved.

In the following short video segment, hear how Coca Cola Bottling have changed their fix pack philosophy as a result of moving. With Oracle Database, they would avoid fix packs unless they “had to”. But with DB2, applying fix packs is much easier and faster, providing faster access to new functionality, performance improvements, and bug fixes. Also, hear about how Coca Cola Bottling have had significant data storage savings thanks to moving to DB2. Who wouldn’t want to reclaim some of that IT budget allocated for storage purchases 🙂

And finally, hear about their experiences with performance boosts and the autonomic computing capabilities in DB2.


Written by Conor O'Mahony

February 23, 2012 at 11:07 am

Ray Wang Compares IBM DB2 and Oracle Database for SAP Environments

with 4 comments

Last week, the Americas SAP User Group (ASUG) hosted a Webcast titled Optimize your SAP Environment While Reducing Costs Webcast Materials. The Webcast was delivered by the inimitable Ray Wang, Principal Analyst and CEO at Constellation Research, together with Jack Mason from SAP and Larry Spoerl from IBM. The Webcast discusses how to deliver world-class performance for SAP applications, whilst reducing the Total Cost of Ownership (TCO) of the underpinning infrastructure. It is full of great practical advice, including direct comparisons of IBM DB2 and Oracle Database as part of that underpinning infrastructure. For more information, and for the commentary that goes with the following chart from this Webcast, make sure to check it out at Optimize your SAP Environment While Reducing Costs Webcast Materials:

Compare Oracle Database and IBM DB2 for SAP - ASUG Webcast

Written by Conor O'Mahony

October 4, 2011 at 8:45 am

Industry Benchmark Result for DB2 pureScale: SAP Transaction Banking (TRBK) Benchmark

with 7 comments

A couple of years ago, IBM introduced the pureScale feature, which provides application cluster transparency (allowing you to create shared-disk database clusters). At the time, IBM had taken their industry-leading clustering architecture from the mainframe, and brought it to Unix environments. IBM subsequently also brought it to Linux environments.

Today, IBM announced its first public industry benchmark result for this cluster technology. IBM achieved a record result for the SAP Transaction Banking (TRBK) Benchmark, processing more than 56 million posting transactions per hour and more than 22 million balanced accounts per hour. The results were achieved using IBM DB2® 9.7 on SUSE Linux® Enterprise Server. The cluster contained five IBM System x 3690 X5 database servers, and used the IBM System Storage® DS8800 disk system. The servers were configured to take over workload in case of a single system failure, thereby supporting high application availability. For more details, see the official certification from SAP.

Written by Conor O'Mahony

September 12, 2011 at 11:16 am

Top 7 Reasons to Use DB2 for SAP Applications

leave a comment »

  1. IBM and SAP work together to optimize DB2 for SAP
    SAP and IBM work together to optimize DB2 for SAP. The joint SAP and IBM teams co-located in Toronto, Canada and Walldorf, Germany make sure that DB2 is optimized and certified for each new release of SAP in a timely manner. DB2 is the only database software with such a close working arrangement. Other database vendors typically take several months to become officially supported by SAP.
  2. SAP Integrates DB2 into SAP Applications
    By integrating DB2 into SAP applications, SAP offers you a single point-of-contact for support. IBM and SAP cooperate in every phase of the software lifecycle to provide you with the best possible integrated product offering.
  3. DB2 has more efficient storage
    SAP environments often have large amounts of data. Some estimates claim that data storage costs represent almost half of enterprise IT infrastructure costs. DB2 typically outperforms other database software when it comes to minimizing data storage.
  4. DB2 is easier to administer
    DB2 automates many DBA activities for SAP environments, including database reorganizations, memory tuning, collection of database statistics, database backups, log file management, and storage allocation.
  5. DB2 Makes SAP Faster
    DB2 has consistent leadership of SAP SD 2-tier and 3-tier performance benchmarks. See for yourself at SAP Standard Application Benchmarks.
  6. DB2 offers High Availability and Disaster Recovery as standard
    DB2 for SAP includes High Availability and Disaster Recovery capabilities for no extra charge. DB2 provides ultra-fast switchovers from the primary to standby systems; for example, in a SAP test environment with 600 users, services were resumed within 11 seconds.
  7. SAP uses DB2
    There can be no greater endorsement than SAP choosing to use DB2 for all of its own SAP applications.

Written by Conor O'Mahony

August 31, 2009 at 6:49 pm

Switch SAP Applications to use DB2 for a Quick Return on Investment

leave a comment »

There is an article at describing how SAP infrastructure changes to databases, servers yield quick returns. The article quotes Derek Prior of AMR Research who says that “some are finding it cheaper to swap Oracle databases in a more Unix-oriented environment to DB2” and that companies are “realizing payback within nine to 10 months“.

This is consistent with what we are seeing at IBM. Here are a selection of quotes from organizations who recently swapped the database software for their SAP applications to DB2:

The migration to DB2 was completed in three months. We estimate that database operational costs have been cut by 68 per cent… The migration was smooth and completed absolutely without a hitch.“—Ralf Rohrer, Head of Server and Storage Operations at Industrielle Werke Basel (IWB)

Thanks to DB2, we are saving around 25 per cent on software licensing and maintenance fees – which means we have more money in the IT budget to spend on solutions that deliver additional competitive advantage for our business.“—Ozcan Soke, IT Manager, Borçelik

Our database is now 43 per cent smaller than before, and some of the largest tables have been reduced by up to 70 per cent. Despite the compression, there has been no impact on batch performance, and our most important online transactions are actually 20 per cent faster with the new version of DB2.“—Roland Heim, SAP Basis Administrator, INTER Versicherungen

Choosing DB2 has delivered significant benefits for our organization: database size has been reduced by 40 per cent and performance is 15 per cent above our targets.“—Brian Visser, IT Operations Director, Central Services at KONE

We expected an improvement of around 20 per cent in terms of system response time, but we found that the new system was actually 40 per cent faster. The DB2 database is even more efficient than we had anticipated. This means that the investments in new server and storage hardware will actually last longer than planned, contributing to a better-than-forecast return on investment, which is very pleasing.“—Peter Boegler, Solution Architect at SAP IT

There are many more such quotes in the DB2 for SAP case studies.

Written by Conor O'Mahony

August 26, 2009 at 10:06 am

Why SAP Chose DB2…

with one comment

Here is a video featuring Dr. Bernhard Wallner from SAP IT explaining why they chose DB2 as the database for their corporate business systems. Of course, it is especially gratifying when SAP chooses DB2 to power it’s own SAP applications. In the video, you will hear lots of great facts like how DB2 improves performance by 40% in the corporate HR system.

Written by Conor O'Mahony

August 25, 2009 at 7:22 pm

Posted in DB2 for LUW, SAP

%d bloggers like this: