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

IBM Db2 Database vs Oracle Multitenant comparison

 

Comparison Buyer's Guide

Executive Summary

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 Database
Ranking in Relational Databases Tools
6th
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
73
Ranking in other categories
No ranking in other categories
Oracle Multitenant
Ranking in Relational Databases Tools
13th
Average Rating
8.6
Number of Reviews
19
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of March 2025, in the Relational Databases Tools category, the mindshare of IBM Db2 Database is 7.0%, up from 6.5% compared to the previous year. The mindshare of Oracle Multitenant is 0.6%, down from 0.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Relational Databases Tools
 

Featured Reviews

SimonHiggins - PeerSpot reviewer
Very scalable with high availability and excellent technical support
The good thing is that there are improvements coming with later function levels for the z/OS Db2. I'd like it if, with the operating system that we've got, z/OS, on the mainframe, it would allow us to refresh the hardware to run Linux dockers on the mainframe. This means this might give us opportunities for different ways of coming into the Db2 environment in the future. We just want a bit more integration with Linux. That said, we are already seeing Linux more readily available on the mainframe environment. Not only have we got the premium operating systems on OS. We can run LPARs on the same mainframe footprint that is also supporting Linux. This is what has improved and made the mainframe environment more competitive. We're also looking at AI for Db2 as well, and machine learning for the future. We know that AI has come out, that we're going to get that, and we're going to evaluate that product next year for Db2. That said, I haven't got any real complaints about Db2 on the mainframe. For the most part, a lot of the problems we have nowadays are to do with communication between the various teams that you would class as stakeholders.
François Dernoncourt - PeerSpot reviewer
Databases are automatically upgraded and cloning of pluggable databases requires just one command
Multitenant has a container database with many pluggable databases. A great feature is that you can upgrade the container to a more recent version and all the pluggable databases are automatically upgraded to that version. Previously it would have required an upgrade for each database. The second great feature is the clone which enables you to get the clone of pluggable databases with one command, as opposed to copying data from one place to another.

Quotes from Members

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

Pros

"When you submit a ticket the response time is quick."
"It has a good feature called pureScale, which is just for scalability. It is a perfect solution for environments where scalability is going to be an issue."
"The most valuable features are the simplicity of the database and the access to Db2 and Db2 information."
"Scalability-wise, I rate the solution a nine out of ten."
"I have found the most valuable feature to be its availability."
"The solution's initial setup is straightforward."
"Db2 database scalability and performance capabilities match our database needs. It covers pretty much everything a database administrator or engineer might need."
"Your iOS, your throughputs, your performance cycles, you cannot touch it with Microsoft or with Oracle scalability-wise. That is far and away the most scalable systems and the highest performing systems of the set of them."
"The database becomes pluggable. Inside this container is called a pluggable database and each application contains this pluggable database inside Multitenant. We can then share resources like control files, memory, etc. This lets you stop and start each application without impacting the others. This resource sharing is the most valuable feature"
"It's easy to use and works great."
"The most valuable features are the speed and ease of use."
"Multitenant has a container database with many pluggable databases."
"It is quite stable. We have not faced any kind of instability in the database."
"You can scale the solution as needed."
"I would rate the scalability a ten out of ten. Our clients are mostly medium and enterprise businesses."
"Our primary use of Oracle includes writing queries for retrieving data for customers without worrying about the customer ID, user ID, as it is automatically connected to each query."
 

Cons

"We need some time to improve the performance. We have to perform a weekly REORG, or else RUNSTATS for the databases."
"In terms of improvements, IBM Db2 can improve its interface and its functionality. Also, the embedded functions should be much richer than the current ones - the functions which are embedded in the engine itself."
"There are some issues with Db2's database file system not being readable. The storage could also be increased, and the monitoring could be improved."
"IBM Db2 Database is not ACID compliant, which would improve it. Db2 lacks Isolation, so when two people are trying to update the same field at the same time it can become stuck. Other newer databases do not have this issue, such as Microsoft SQL, Oracle DB, PostgreSQL, and SAP HANA."
"The capabilities of this solution could improve."
"The product’s user interface is not easy to use."
"I would like to see some artificial intelligence brought into the solution."
"The data table names are very short which is not user-friendly compared to the Oracle SQL server. It should have longer column and table names."
"The user interface for this solution can be made better."
"Technical support could be faster."
"This solution is a bit complicated when collecting from containers - that feature should be a bit better."
"It can be complicated to scale up the solution, but it's scalable."
"From the scope of improvement, I would say that people are adopting new query options. Certain databases like MongoDB adopt new query options so that they can just pull the data."
"There is room for improvement in customer service and support."
"There are many functions where changes are not easy to implement, and we try to avoid modifying these areas due to security issues and the complexity of maintaining them."
"The solution lacks a GUI for commands."
 

Pricing and Cost Advice

"I rate the product pricing a nine out of ten."
"We purchase the product's yearly license."
"There is a license for this solution and we pay every three years."
"Compared to other databases, Db2 is relatively cheaper."
"I would rate the pricing a five out of ten. It's not super expensive, but also not cheap."
"The total cost of the solution depends upon the PVU licensing"
"Clients are required to purchase a license."
"We normally handle large size businesses and as far as I am aware, the license is negotiable based on the number of users and the quantitative data."
"The price is worth the quality."
"For me, I will go with it if I have the budget. Some features are nicer than before, but at the end of the day, you always have a limited budget. I prefer to upgrade and get a specific hardware when possible. At the end, you will have to make a compromise. You will not get everything you would have liked to have."
"This solution is a little bit pricey."
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
839,319 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
62%
Financial Services Firm
8%
Computer Software Company
4%
Manufacturing Company
3%
Financial Services Firm
23%
Manufacturing Company
7%
Computer Software Company
7%
Hospitality Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about IBM Db2 Database?
Db2 database scalability and performance capabilities match our database needs. It covers pretty much everything a database administrator or engineer might need.
What is your experience regarding pricing and costs for IBM Db2 Database?
IBM Db2 is an expensive solution. While I am not heavily involved with pricing, additional companies provide capabilities or products like those from BMC, which many installations might also purchase.
What needs improvement with IBM Db2 Database?
The user interface is old and needs to be improved. It doesn't match the responsive and suggestion-rich UI of cloud solutions. New functions don't come to mind.
What do you like most about Oracle Multitenant?
The best thing about Oracle Multitenant is its ability to consolidate multiple databases into one engine.
What is your experience regarding pricing and costs for Oracle Multitenant?
I am not connected to the financial aspects, so I am unable to provide details.
What needs improvement with Oracle Multitenant?
There are many functions where changes are not easy to implement, and we try to avoid modifying these areas due to security issues and the complexity of maintaining them. Also, support can be impro...
 

Also Known As

DB2
Oracle Pluggable Database
 

Overview

 

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 Toronto
An Post, National Oilwell Varco, SAS Institute, Sportmaster, Y-Telecom
Find out what your peers are saying about IBM Db2 Database vs. Oracle Multitenant and other solutions. Updated: March 2025.
839,319 professionals have used our research since 2012.