IBM Db2 Database Review

Good results, robust stability, and good support

What is our primary use case?

We are using it for our SAP system.

What is most valuable?

Db2 Database has given us good results since we have started to use it. We predominantly use IBM hardware, and this is one of the reasons why we started to use Db2 Database. 

Db2 Database has a very good HADR capability. High availability resilience is also good in this solution. It also has pureScale, which allows you to upgrade one node to get very good and high-level resilience. If you are using a database on five nodes, you can take one node down, upgrade that, and let that node up. You can then bring the second node down, upgrade that, and so on.

What needs improvement?

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.

For how long have I used the solution?

I have been using this solution for five or six years.

What do I think about the stability of the solution?

Initially, there were hiccups, but now, it is a robust database. The only limitation that we have found is crash recovery. In terms of bugs, every database will have some bugs that will hit you. I don't see much in terms of bugs in Db2 Database. Whatever known bugs are there, we get those issues.

How are customer service and technical support?

They are really very good. Overall, if I have to give a rating, I will give them an eight and a half or a nine out of ten. Their response to our requirements is quite good. They have good resources at the technical end. They take us very seriously. It might be because we are one of the largest accounts. I don't know what happens with medium-scale industries or small-scale industries. 

Which solution did I use previously and why did I switch?

We migrated from Oracle Database to Db2 Database because it was quite a good and cost-effective solution. Oracle Database was coming out to be expensive.

How was the initial setup?

The initial setup was complex altogether. It was complex because we were moving from Oracle Database to Db2 Database. A lot of code changes were required. 

What's my experience with pricing, setup cost, and licensing?

We did not buy it. It came with our hardware without any complimentary maintenance. If I compare Db2 Database with Oracle Database, its price is lower than Oracle Database.

What other advice do I have?

I would recommend Db2 Database to others because, as time passed, they have made a lot of changes, such as crash recovery. The time of crash recovery is reduced by almost 60% to 70%. Db2 Database also has Db2 BLU, which actually is in-memory. We have not explored this particular feature, but I would recommend others to explore it. With Db2 BLU, it becomes equivalent to HANA. We are seeing it being used a lot in large banks etc.

Among Oracle, Db2, and SQL databases, I would rate Oracle first, Db2 second, and SQL third. I personally believe Oracle is the most robust database. Db2 is the second robust database.

I would rate Db2 Database an eight out of ten.

**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More IBM Db2 Database reviews from users
...who work at a Financial Services Firm
...who compared it with Oracle Database
Add a Comment