IBM Db2 Database Review

Affordable, reliable, and has good performance but the interface needs improvement


What needs improvement?

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.

For example, I can find more DEPTH functions in Oracle than in Db2. Also, SQL Server still has richer functions than Db2.

For how long have I used the solution?

I'm working with Db2 for two years now, since we migrated to the Cloud and converted from the SQL Server.

I work with Db2, SQL Server, and Oracle.

I'm a specialist in the product, doing support. I received special training for it.

What do I think about the stability of the solution?

In terms of stability, I have some issues, but I cannot figure out if this is due to the database or the platform in the engine itself.

Additionally, sometimes I find the response is not good, meaning a reasonable response time. For a while the team was working fine in another engine. What I look for is the design and whether the syntax is different. I don't know. I'm really not certain about the holes.

What do I think about the scalability of the solution?

Since it's on the Cloud, it's pretty much scalable with no limits.

What about the implementation team?

We did get a specialist to help with the setup and deployment to the Cloud.

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

IBM Db2 was much cheaper as a package than using other products. This is because IBM supplied a package with its product. It's an application. So it was much more efficient and a stronger competitor in that regard.

Which other solutions did I evaluate?

Performance-wise, Oracle is the best solution. It is much more reliable. Regarding the end user administration and the functions available, SQL Server is much easier.

They have much more user-friendly interfaces. Regarding Db2, I'm a little bit in doubt. I don't see that it is significantly different when I went from SQL Server to Db2. I have not seen any significant improvements or changes.

What other advice do I have?

The advice I would give is to have a good administrator. Have an administrator that is skilled in that field so he can tune the database's performance and understand the know-how of how to administrate that platform.

Overall, I would give IBM Db2 a 7 out of 10. 

For it to be higher, it needs a better interface. It is very important to have. I am very keen to have such an interface.

Which deployment model are you using for this solution?

Public Cloud
**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
Guest