DB2 9.7 is streets ahead of Oracle Database 11gR2 in ease of use study

Over the last few months our team of experts have undertaken an objective assessment of the complexity of several routine DBA activities, comparing Oracle Database 11g R2 and DB2 9.7.  During the course of this study we found that DB2 9.7 holds a significant advantage in every single category we tested! 

The DBA tasks that we used were: 

  • Installation
  • Enabling table compression
  • Enabling index compression
  • Backup and recovery
  • Automatic memory tuning
  • Authorisation

“Lower complexity is directly correlated to time savings and with staff costs consuming an ever-increasing percentage of IT budgets, this study proves that DB2 9.7 demonstrates tangible TCO benefits over Oracle 11g” Iqbal Goralwalla, Head of DB2 Midrange, Triton Consulting. 

We were hugely impressed with the results that DB2 9.7 produced.  As you can see in the table below, Index Compression came out as an astounding 100% less complex to perform in DB2 9.7 than in Oracle Database 11gR2.  Overall DB2 9.7 is significantly easier to maintain than Oracle 11gR2. 

Task Complexity Metric DB2 Advantage
DB2 9.7 Oracle Database 11gR2
Installation 326.5 570.5 43%
Data Compression 119.50 238 50%
Index Compression 0 189.50 100%
Backup and Recovery 72.5 439 83%
Automatic Memory Management 62.5 617 90%
Data Access Control 138 730 81%


DB2 9.7 Vs Oracle 11g Complexity analysis  

The white paper with a breakdown for each task can be downloaded here – https://www14.software.ibm.com/webapp/iwm/web/signup.do?lang=en_US&source=sw-infomgt&S_PKG=analyst-db2_oracle_triton

Complexity analysis is a new approach to evaluating and communicating the usability of software and is based on established research as described in this document http://www-01.ibm.com/software/ucd/Resources/ComplexityAnalysisDGarticle.pdf.

This entry was posted in DB2, DB2 9.7, IBM, Oracle Vs DB2 and tagged , , , , , . Bookmark the permalink.

One Response to DB2 9.7 is streets ahead of Oracle Database 11gR2 in ease of use study

  1. Pingback: Oracle Database is dramatically more complex to install than DB2 9.7 | Triton Consulting

Comments are closed.