We performed a comparison between IBM Db2 Database and Oracle Database based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The solution is easy to install and simple to maintain. The most valuable aspect of the solution is its general user-friendliness for users of all kinds."
"The solution is very stable, in both hardware and database."
"Db2's best features are that it's self-maintaining and self-monitoring, which means I have to view and monitor the database far less often."
"The solution is a very stable relational database and has integration with legacy systems. It is a great product."
"IBM DB2 pureScale Feature is valuable."
"it is very stable and runs smoothly once it is deployed and it is almost maintenance-free."
"The most valuable feature of the IBM Db2 Database is security."
"When you submit a ticket the response time is quick."
"Overall, from a technical perspective, the solution is very strong."
"As a database, the solution has been number one from the beginning."
"In general, Oracle is quite good. It's a large database that houses many applications."
"It is a reliable database warehouse solution that is transparent to the end user."
"I like the backend robustness of the database, and the security capabilities inherently that are in the product itself."
"The reporting feature was fine for what we were using it for. Oracle Database has been serving its purpose, and I was happy."
"The features that I have found most valuable are things like cluster setup and RAC One. We are using the main CQN and third party plugin support right now. We are relying on different languages support that we are getting from the Oracle side. It is one of the major areas in which Oracle excels compared to other databases."
"I've never faced any stability issues with the product. I don't recall any bugs, glitches, or crashes. I'd say it's fairly stable and shouldn't cause anyone issues in that regard."
"GUI needs improvement."
"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 queries can be difficult for beginners because there are so many. I would like to see more use cases for flow analysis that enable us to correlate the flow with events. Adding this feature in a QI format would be good for beginners."
"The ease of use, or ease of management, could be improved."
"The application development requires a Java developer and not every company has these resources."
"Performance is something that can be improved with DB2."
"The only drawback that we see in Db2 Database is the crash recovery. When there is a crash and somebody has to do the recovery, Db2 Database first stops, and then it does any crash recovery. In Oracle Database, crash recovery happens within the database. The database is not shut down."
"The management of Db2 should be simplified because there are not too many specialists in this area, and the learning curve of Db2 specialists is very long. After the courses, probably it takes one and a half or two years to get to the point when you are using the product properly in the production systems. So, the complexity is very high, and the most important thing is to simplify the management of the product, including self-maintenance. They should simplify the installation, management, and monitoring to simplify the product. It takes too long for a person to be a specialist in this product."
"It is expensive."
"The software really doesn't need any improvement, but the way they do the billing should be improved. They charge by all the chips on the server, whether you use them or not. If you have a server that has 64 chips on it and you use one chip, they charge you for 64, and that's a terrible business model."
"The product is expensive."
"There are a lot of additional costs. That is the reason we are only leveraging for transactional related purposes, so that we do not spend so much on doing the same thing on Oracle. That is the reason we are looking for open source databases now."
"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."
"Oracle needs to improve its cluster technologies. They need to improve in the cluster technology using ARC due to the fact that sometimes people think that they have a redundant server when they are using ARC with the cluster and think that will increase the performance. In reality, if they are using ii with a big workload, sometimes the performance is not increasing, and can sometimes actually impacts it in such a way that there's some degradation in the performance."
"Problems can arise if there are too many requirements or a lot of details which must be applied to connect the software to the database."
"The pricing needs to be improved."
IBM Db2 Database is ranked 6th in Relational Databases Tools with 66 reviews while Oracle Database is ranked 2nd in Relational Databases Tools with 278 reviews. IBM Db2 Database is rated 8.2, while Oracle Database is rated 8.6. The top reviewer of IBM Db2 Database writes "Very scalable with high availability and excellent technical support". On the other hand, the top reviewer of Oracle Database writes "Supports a large volume of transactions compared to other databases". IBM Db2 Database is most compared with SQL Server, SAP HANA, Teradata, MySQL and Oracle Database In-Memory, whereas Oracle Database is most compared with SAP HANA, SQL Server, MariaDB, Amazon Aurora and MySQL. See our IBM Db2 Database vs. Oracle Database report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools 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.