Try our new research platform with insights from 80,000+ expert users

IBM Db2 Warehouse vs Oracle Database Appliance comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

IBM Db2 Warehouse
Ranking in Data Warehouse
11th
Average Rating
7.8
Reviews Sentiment
6.6
Number of Reviews
11
Ranking in other categories
No ranking in other categories
Oracle Database Appliance
Ranking in Data Warehouse
5th
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
44
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of June 2025, in the Data Warehouse category, the mindshare of IBM Db2 Warehouse is 2.3%, up from 1.9% compared to the previous year. The mindshare of Oracle Database Appliance is 5.3%, down from 6.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
 

Featured Reviews

Ismail Aboulezz - PeerSpot reviewer
Enhancements in data analysis and decision-making elevate overall performance
The most valuable features of IBM Db2 Warehouse ( /products/ibm-db2-warehouse-reviews ) include its availability, easy integration, ability to deal with a large size of data, excellent performance with no delays, powerful security mechanisms, and effective support. The response time is very quick, and the technical manuals and support from IBM are of high quality. Additionally, it is easy to install, troubleshoot, operate, and secure the environment.
Ahmed-Yehia - PeerSpot reviewer
Enhanced performance and simplified operations with integrated features
All improvements for ODA are already applied or enhanced in Exadata. ODA is mainly for small businesses or limited businesses and is used predominantly for database warehouses and not for OLTP databases. You can only scale storage, not developer nodes. It's priced a little higher, which could be optimized for small or medium businesses.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The analytics engine is not bad at forecasting predictions."
"It can be mounted on the cloud, which is a huge plus. If the client, for example, starts small with on-premise deployment and then it rapidly needs to grow, we can transfer this to the cloud easily."
"It can scale effectively as long as resources are available."
"Some of the best features are stored procedures, parallelism, and different indexing strategies."
"The most valuable features of IBM Db2 Warehouse include its availability, easy integration, ability to deal with a large size of data, excellent performance with no delays, powerful security mechanisms, and effective support."
"The solution is stable."
"The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data."
"Provides good security and reliability."
"The solution is pretty automated, which takes out the possibility of human error."
"Oracle Database Appliances are specifically designed for Oracle databases. They have built-in utilities and tools that simplify management, making them the best option for Oracle database management systems."
"The performance of the system is the solution's most valuable aspect. In combination with the database, it gives perfect results. It's a better system than using other kinds of integrated systems. In general, the ODA control is much simpler to use and offers up the best performance."
"The main feature is the management and manageability of the tool. We can create a VM on a laptop within a couple of clicks."
"NVM Express (NVMe) solid-state drives: This technology brings outstanding I/O performance for midsize databases. We have tested it by doing POCs on customer sites and the results were quite satisfying."
"The tool is a specific and effective system. I am impressed with its usability."
"The most valuable feature is the performance."
"The most valuable features are related to engineering systems, where Oracle acts as a hyperconverged infrastructure."
 

Cons

"There were some initial challenges with IBM Db2 Warehouse about eight months ago when I worked in this environment. When I coordinated with IBM support, they mentioned that the memory was insufficient for our needs. Our business environment required significantly more memory than the previous cluster could provide. Consequently, we have worked closely with on-site IBM technical personnel to address this issue."
"It takes a long time to have a new version or release, similar to Oracle."
"The biggest problems we have is when the backup solution is failing or slow and we run out of log space, which has happened probably a couple of times in the last four years."
"In terms of improvement, IBM Db2 Warehouse should be more scalable."
"Lacks sufficient documentation and particularly in Spanish."
"There should be more material available for training and training should be free."
"Responding to support tickets takes a lot of time. It can range from two to four days, even for critical issues."
"IBM Db2 Warehouse needs to improve its interface."
"In terms of what can be be improved, I'd say Artificial Intelligence, AI. It would be really helpful if AI was incorporated within the solution."
"Oracle's product support is an area of concern where improvements are required."
"I would rate the scalability a seven out of ten. It has some problems. Databases are huge. This leads to needing more and more RAM and capacity resources, making it hard to scale. Because of this, we use Exadata. That's definitely a point for improvement."
"The license cost could be cheaper, especially for long-term contracts."
"The product's pricing is too high. We plan to migrate to another database in three to four years."
"Oracle could improve its capacity for built-in visualization."
"The setup is a bit complex."
"Oracle Database Appliance could improve by having better integration."
 

Pricing and Cost Advice

"In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."
"The price should be lower."
"I don’t know ODA and alternative system prices. But Oracle the database license is quite expensive and a lot of my customers plan to migrate to open source databases like PostgreSQL."
"The solution's pricing is very high."
"On a scale from one to ten, where one is cheap and ten is expensive, I rate the solution's pricing seven and a half or eight out of ten."
"Compared to Oracle Exadata, Oracle Database Appliance is affordable."
"The solution may be expensive, but when we consider the problems it solves, the stability it provides, and the fact that we don't have to buy separate parts and assemble them into a system, it becomes more affordable."
"Oracle’s pricing is ridiculously high."
"In regards to licensing, it is cheaper to maintain for Oracle applications, and it's an all-in-one solution."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
856,873 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
45%
Financial Services Firm
16%
Computer Software Company
7%
Government
5%
Financial Services Firm
29%
Computer Software Company
12%
Manufacturing Company
9%
Government
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about IBM Db2 Warehouse?
The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data.
What is your experience regarding pricing and costs for IBM Db2 Warehouse?
The pricing for medium and large environments is almost the same as Oracle. I rate the pricing as six out of ten.
What needs improvement with IBM Db2 Warehouse?
There is room for improvement in optimizing certain processes, but most issues arise from my data, hardware architecture, and resources, not from IBM Db2 Warehouse itself.
What do you like most about Oracle Database Appliance?
Oracle Database Appliance provides high stability.
What is your experience regarding pricing and costs for Oracle Database Appliance?
While I'm somewhat familiar with standard licensing, pricing isn't really my area of expertise. However, Oracle is on the higher end of the pricing spectrum, along with SAP.
What needs improvement with Oracle Database Appliance?
There is room for improvement in better integration with third-party tools, such as Power BI or Redshift. When dealing with federated data sources, this integration can be a challenge.
 

Also Known As

InfoSphere Warehouse, IBM InfoSphere Warehouse
X5-2
 

Overview

 

Sample Customers

Alameda County Social Services Agency, Sui Southern Gas Company Limited
LifeLock, Incarlopsa, Al Yusur Industrial Contracting
Find out what your peers are saying about IBM Db2 Warehouse vs. Oracle Database Appliance and other solutions. Updated: May 2025.
856,873 professionals have used our research since 2012.