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
7th
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 May 2025, in the Data Warehouse category, the mindshare of IBM Db2 Warehouse is 2.2%, up from 1.7% compared to the previous year. The mindshare of Oracle Database Appliance is 5.3%, down from 6.3% 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.
AdnanNaseem - PeerSpot reviewer
Offers built-in utilities and tools that simplify management
Oracle often releases updated versions of Database Appliance with improvements. However, I think Oracle should focus on further automating database management and IT-related tasks, such as backups. They've made progress with daily database stat automation, which is a good feature. Moreover, every product benefits from new functionality over time. I would like to see a centralized terminal where we can easily manage the database and its components with drag-and-drop functionality instead of relying solely on commands. So, I would like to see a centralized dashboard. Other areas of improvement include customer service and support, and scalability.

Quotes from Members

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

Pros

"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."
"Provides good security and reliability."
"Some of the best features are stored procedures, parallelism, and different indexing strategies."
"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."
"The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data."
"The analytics engine is not bad at forecasting predictions."
"The solution is stable."
"It can scale effectively as long as resources are available."
"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 most valuable features are related to engineering systems, where Oracle acts as a hyperconverged infrastructure."
"The product is good value for money. It is a secure solution."
"We value the appliance architecture with its “everything-in-a-box” highly standardized setup."
"The product’s valuable feature is its capability to pre-configure and pre-install the settings."
"Oracle is a stable database."
"The database is solid."
"Oracle offers ETL with PL/SQL as a programming language for SQL programming, which is majorly used in data engineering."
 

Cons

"There should be more material available for training and training should be free."
"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."
"Lacks sufficient documentation and particularly in Spanish."
"Responding to support tickets takes a lot of time. It can range from two to four days, even for critical issues."
"In terms of improvement, IBM Db2 Warehouse should be more scalable."
"The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."
"The biggest challenge anyone could have with Db2 Warehouse is their references or online resources and documentation. They are very, very, very limited on the web."
"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."
"You can only scale storage, not developer nodes."
"The product's pricing is too high. We plan to migrate to another database in three to four years."
"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."
"It isn't as popular as AWS, GCP, or Azure as it lacks scalability and cloud-native services like containerization."
"Virtualization needs improvement. It's not easy to back up the virtual machines in the Oracle VM architecture. I would also like to see native support for Veeam Backup Software."
"Oracle Database Appliance is stopping support for the standard edition and only continuing support for the RAC One Node. They did not inform us and we are having problems with our customers. We are not having to change our systems from standard to something else."
"We would like the ability to add more storage without having to upgrade to Oracle Exadata."
"The setup is a bit complex."
 

Pricing and Cost Advice

"In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."
"Oracle Database Application's support and maintenance are included in the contract."
"The price of the solution should be less expensive. However, they will increase the price more."
"In regards to licensing, it is cheaper to maintain for Oracle applications, and it's an all-in-one solution."
"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."
"I would rate the pricing a four on a scale of one (high price) to ten (low cost)."
"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."
"The solution's pricing is very high."
"You must pay for the license."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
851,604 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
56%
Financial Services Firm
13%
Computer Software Company
6%
Government
4%
Financial Services Firm
30%
Computer Software Company
12%
Manufacturing Company
9%
Government
9%
 

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.
851,604 professionals have used our research since 2012.