IBM Db2 vs. Oracle Database

IBM Db2 is ranked 5th in Relational Databases with 12 reviews vs Oracle Database which is ranked 1st in Relational Databases with 32 reviews. The top reviewer of IBM Db2 writes "The most valuable features automated security administration and reporting". The top reviewer of Oracle Database writes "Enables us to combine all the sophisticated architectures in the market". IBM Db2 is most compared with Oracle Database, IBM Informix and SQL Server. Oracle Database is most compared with IBM Db2, SQL Server and Tibero. See our IBM Db2 vs. Oracle Database report.
Cancel
You must select at least 2 products to compare!
Most Helpful Review
Use Null Product? Share your opinion.
Find out what your peers are saying about IBM Db2 vs. Oracle Database and others in Relational Databases.
306,037 professionals have used our research since 2012.

Quotes From Members Comparing IBM Db2 vs. Oracle Database

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
Pros
Some of the most valuable features are the scaling from a small very cheap installation to a very large enterprise installation. In addition, the backups and assistance are good.It has a good, stable performance.​Scales well enough for a relational database.

Read more »

I really appreciate the performance of Oracle. When using AWR records you can really see where a problem is. You can get advice about which queries are the heaviest for the database. You also can see advice for indexes. If an index isn't used, then you can just remove it to improve performance. This is a really good feature. Also, the JDBC connection is quite good. Finally, the object types are really good, the types of tables you can use in PL/SQL are also really helpful.Using the product, we make less mistakes, are more organized and faster than if we did it any another way.Compared to other databases, Oracle Database is very simple to manage in terms of the database itself.It stores a lot of data in a short time.It is flexible, scalable, and a true Enterprise RDBMS.High availability using real application clusters.It gives DB consistency, supports disaster recovery (DR), is tunable, and handles large DB sizes.You can install Oracle Database software, patching, and create/configure Oracle databases in silent using scripts

Read more »

Read more »

Cons
The initial set up was complex.Do not use support. Freely available documentation is a bit weak.​​Not very solid compared to its competitors' products.​Some of the internal rearrangement in the administration is not as straightforward as it is in competing products.

Read more »

There are a lot of bugs in the Oracle Database, and it would be better if the bugs would be solved more quickly than they are today.In general, the support is not good since most of the time the person whom you are given to is not so professional.Integration with big data would be helpful since we are planning to load a lot of big data.A lot of features have bugs or choose the wrong way to process data.Auditing could be improved, especially granular auditing. The unified audit trail in 12c is great, however its extraction in a highly busy environment is quite a challenge.The compression does not give much value-add or provide performance benefits as was highlighted.Cloud installations using Oracle are not supported by SAP.​​​Upgrade is the most critical phase for the lifecycle of a database. In order to be sure that the migration succeeds, you need to be up-to-date. Therefore, regularly install the patchset and security updates.

Read more »

Read more »

Pricing and Cost Advice
They are competitive and honest (compared to how peer firms approach licensing conversations). ​Compared to Oracle, it is so much cheaper.

Read more »

The price is very expensive for the support.The main issue where I feel that Oracle still has a problem is with the licensing. Licensing is still expensive and the reason why today most startups use other, cheaper databases. Those other databases are much less sophisticated than Oracle.​The license cost need to be optimized. The licensing cost is very high compared to other RDBMS.Be prepared to pay for consulting services, and do not underestimate the time required to find and hire good quality database administrators.

Read more »

Information Not Available
report
Use our free recommendation engine to learn which Relational Databases solutions are best for your needs.
306,037 professionals have used our research since 2012.
Answers from the Community
Rhea Rapps
Rehana ParvinReal User

I think -- Oracle is well known for its performance and security feature and continuous efforts to reach the highest level of performance.
A few comparisons are given below:
1. Oracle has multi version read consistency -- but not in DB2
2. In oracle, neither read nor write blocks each other-- DB2 -read blocks write and write blocks read
3. No Dead locks under load in Oracle whereas deadlock is a serious problem in DB2
4. In Oracle --intelligent advisories such as SQL Tuning, Index, Summary, MTTR but in DB2 only Index advisory presents. In terms of Self-tuning capabilities-- Oracle has Automatic Performance Diagnosis, Automatic SQL Tuning , Self-tuning memory, free space, and I/O management and so on but in DB2 No equivalent or limited capabilities
Besides all good features exist in Oracle but it is bit complex. When problem occurs then figuring out the right problem in a very short time has become a challenge, Also Oracle is bit expensive.
There are a lot more difference. I think you can find good resource by searching online.
I think all database software has their own advantages and disadvantages. Depending on the budget and compromises in which feature loss they can afford--companies decide their choices.


05 April 18
Martin Spratt (2300+ Connections)Real User

Both DB2 and Oracle are legacy relational databases. 20+ years ago you might pick DB2 for reliability and scalability, but today you would choose Oracle for the sheer size of partners, applications, skills and tools available. So if you have to pick today, I would choose Oracle (I am an ex IBM DB2 Lab person and used to be VERY DB2 bias as it's an excellent engine)... and if I ask you more detailed application and business landscape questions I would recommend decommissioning BOTH those legacy databases and move to PostgreSQL, MariaDB or MySQL (MySQL is ironically now owned by Oracle too), and cloud host your database farm. If you had to pick a legacy "perpetual license" relational database I would go wall to wall MS SQLServer. That's what I would generally recommend without knowing more about your application or business landscape. (SAP, Apps, Mobility, Cloud, Regulatory, Security, HA, Scale, etc etc).

06 April 18
Sydney ChidambaramConsultant

I have worked on both, I kind of agree and disagree with the first repsonse, Both are very stable databases, I work currently on Oracle, and have worked for 20 years on DB2 on I-series and S38.
Both have its place, it is totally dependant on your requirement. However DB2 is shipped free with the IBM platform, oracle comes at a cost.

Your business requirement and the person in charge of your IT systems should be able to tell you which one would suit your business, All the other databases mentioned can also do the job.

A full business analysis will need to be done to understand where your business is now and what the future expectation is so that you can make the best choice.

06 April 18
Mario SoberanisReal User

IBM DB2 is a real legacy system database, that is use in old companies like
telecom, its really couple with the mainframes of IBM really robust but
wasn't build with the internet in mind Oracle on the other hand is a more
modern Database it has more use cases and it also super robust but really
expensive (both are fore big companies) the main differences is that Oracle
runs on normal Linux box and DB2 has to work on a IBM mainframe ... the
language is more dynamic and modern in oracle

hope this helps a bit what is better is alway a "it depends on what you
want to build" for me I think a more modern noSQL data base is better in
this post internet and cloud era

05 April 18
Pratap NegiConsultant

Few more differences......
While IBM mainframe DB2 has a decades-long head start on the mainframe, UDB and Oracle are in a head to head competition for implementing a vast array of security features.
Oracle offers the integrated APEX development platform and SQL*Forms.
Oracle has the Procedural language SQL (PL/SQL) vs. DB2 UDB with their SQL Procedural language (SQL/PL).
Both UDB and Oracle offer a host of HA features for continuous availability. Oracle offers RAC clusters for shared database, plus replication solution vs. Oracle Streams, Oracle Data Guard and Oracle advanced multi-master replication.
While both UDB and Oracle have ANSI standard SQL, vendors have a strong incentive to add "extensions", such as Oracle with their unique DECODE operator.
Both UDB and Oracle are struggling to incorporate automated features to make database administration easier and more automated. For Oracle we see automated storage management (ASM), automated memory management (AMM), and automated database diagnostic management (ADDM).
A critical area of database management, both UDB and Oracle offer backup and recovery features. Within Oracle's Recovery Manager (RMAN), we see block-level backups and hot backups.

05 April 18
Ranking
Views
11,088
Comparisons
7,058
Reviews
12
Followers
276
Avg. Rating
8.7
Views
33,920
Comparisons
9,192
Reviews
34
Followers
489
Avg. Rating
8.6
Unranked
In Relational Databases
Top Comparisons
Compared 33% of the time.
Compared 20% of the time.
Compared 19% of the time.
See more IBM Db2 competitors »
Compared 26% of the time.
Compared 18% of the time.
Compared 10% of the time.
See more Oracle Database competitors »
Compared 29% of the time.
Also Known As
DB2Oracle 12c, RDBMS
Learn how it works
IBM
Oracle
Null Vendor
Video Not Available
Overview
DB2 Enterprise for Linux, UNIX, and Windows is the ideal data server for the most demanding workloads. New XML support is designed to help firms minimize the time and effort it takes to persist and use their XML data reducing development costs and improving business agility.

Oracle Database 12c introduces a new multitenant architecture that makes it easy to consolidate many databases quickly and manage them as a cloud service. Oracle Database 12c also includes in-memory data processing capabilities for breakthrough analytical performance. Additional database innovations deliver new levels of efficiency, performance, security, and availability. Oracle Database 12c comes in two editions to fit your business needs and budget: Enterprise Edition and Standard Edition 2.

For more information on Oracle RDBMS, visit Oracle.com

Information Not Available
OFFER
Learn more about IBM Db2
Learn more about Oracle Database
Learn more about Null Product
Sample Customers
Knorr-Bremse, Mizuho Bank Ltd., Australian Government Department of Defence, SCHWENK Zement, Friedhelm Loh Group, YAZAKI Europe Limited, Ekornes ASA, Baldor Electric, VSN Systemen BV, Lion Brewery (Ceylon) PLC, PLANSEE Group, TE Connectivity, Hansgrohe SE, Openmatics, University of TorontoAgncia Nacional de guas, Anbima, Aria Systems, Asiana Airlines, Astelit LLC, Australian Finance Group, Banco Occidental de Descuento, Bharat Petroleum Corporation Limited, BT, Caja de Seguros S.A., Casas GEO S.A.B. de C.V., Comic Relief UK, Corsair Components Inc., CSAM Health AS, CSOB Group, Datacraft Solutions, DenizBank A.S., Department of Treasury and Finance WA, Office of State Revenue, Deutsche B_rse AG, Deutsche Lufthansa AG, Deutsche Messe AG, Digicel Haiti, DPR COSEA, Essar Group, Essatto Software Pty Ltd, Farmšcia e Drogaria Nissei Ltda., Fomento Econ‹mico Mexicano S.A.B. de C.V. (FEMSA), FundaÊo Petrobras de Seguridade Social, Future Group, GFKL Financial Services AG, Grupo Posadas S.A.B. de C.V., Grupo Sinosserra, Guerra S.A. Implementos Rodovišrios, Hanatour International Service, Hays plc, Henan Mobile Co. Ltd, Hochschule Hof, Hong Kong and China Technology (Wuhan) Co. Ltd (Towngas Technology), Industries Corpa_al C.A., Infrastructure Development Finance Company Limited, Instituto Brasileiro de Geografia e Estatstica, Instituto Mexicano de la Propiedad Industrial, Kcell, LinkShare Corporation, MercadoLibre Inc., MetLife Inc., Nextgen Distribution, €BB-IKT GmbH, Octagon Research Solutions, Pacific Lutheran University, Paragon Data GmbH, Ping ltd., PJSC Trustbank, Prodaub _ Processamento de Dados de Uberl_ndia, Purdue University, Redknee Inc., Robi Axiata Limited, Shanghai Infoservice Technology Co. Ltd, Shanghai Sihua Technologies Co. Ltd, Sistema de Aguas de la Ciudad de M_xico, Solihull Metropolitan Borough Council, Suddenlink Communications, Suprajit Engineering Limited, Tallink Grupp, Terminales Ro de la Plata S.A., Therap Services LLC, Think Passenger Inc., Trafigura, Transmed S.A.L Lebanon, ValeShop, VelQuest Corporation, Vodafone Group plc, West Virginia Network, WIND Hellas Telecommunications S.A
Information Not Available
Top Industries
REVIEWERS
Financial Services Firm
38%
Insurance Company
25%
University
13%
Transportation Company
13%
VISITORS READING REVIEWS
Financial Services Firm
29%
Logistics Company
14%
Comms Service Provider
11%
Insurance Company
9%
REVIEWERS
Financial Services Firm
14%
Government
11%
Insurance Company
8%
Comms Service Provider
8%
VISITORS READING REVIEWS
Financial Services Firm
25%
Media Company
13%
Manufacturing Company
9%
Energy/Utilities Company
8%
No Data Available
Company Size
REVIEWERS
Small Business
20%
Midsize Enterprise
13%
Large Enterprise
67%
VISITORS READING REVIEWS
Small Business
10%
Midsize Enterprise
25%
Large Enterprise
65%
REVIEWERS
Small Business
14%
Midsize Enterprise
22%
Large Enterprise
65%
VISITORS READING REVIEWS
Small Business
18%
Midsize Enterprise
24%
Large Enterprise
58%
No Data Available
Find out what your peers are saying about IBM Db2 vs. Oracle Database and others in Relational Databases.
Download now
306,037 professionals have used our research since 2012.
We monitor all Relational Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.

Sign Up with Email