If you were talking to someone whose organization is considering IBM Db2 Database, what would you say?
How would you rate it and why? Any other tips or advice?
I have experience working with both Oracle and Db2. Comparing the two products, I would recommend Db2. Both Oracle and Db2 have some unique features that separate them. Although they are different, in comparing the two databases, they are both enterprise grade databases with lots of good features. But from my point of view, Db2 is much better. On a scale from one to ten where one is the worst and ten is the best, I would rate Db2 as an eight. It is not rated higher because I think that there are things that can be improved. It is currently not perfect. The graphical tools are not good. It is very common for GUI interfaces in IBM products to be lacking. For the first-time user who has no experience with it, the GUI will not seem very straightforward. If you had to work with it for four years, then you get used to it. But for the first-time users, it is not that user friendly. If some of the user-interface features can be enhanced, it could be a nine. Db2 is a good database. It is for structured data and there is always room for improvement. It requires an experienced person to handle it.
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.
There is a lot of documentation available. I was, however, able to find what I needed through Google. For our clients who have a large scale enterprise, we suggest DB2 and mid-scale enterprise customers we suggest SQL Server or others. It's a better solution, it's better on the application. The purpose of DB2 is for a data warehouse or with data analytics. I would rate this product an eight out of ten.
This is a robust and stable product but it's expensive. I would rate this solution an eight out of ten.
We use the on-premises deployment model. The solution is suitable for big organizations, big financial institutions, government, ministries, the army, insurance companies, etc. It's not for small end-users. I'd rate the solution nine out of ten. The learning curve for the Db2 specialist is high. To become a specialist, under production level, takes two years. It's a complex product.
I'd rate the solution a six out of ten.
I don't think that we will be changing solutions within the next year. I would rate this solution a seven out of ten.
I would definitely recommend this solution to somebody considering it. I would advise that if you are looking to install it, you should have internal competence and internal skill, don't only use external support that is provided by IBM. You should have internal knowledge and competency for Db2 management. The performance is very critical. The software developer needs to have good knowledge of the programming technique in order to avoid the problem on the performance side. The performance of Db2 depends on the system, on how you installed it. From the application part, it depends on how you developed code, how you wrote the code because if you write bad code you will have a serious performance problem. Db2 is a very old product, but also a very stable product. It's really difficult to imagine something different from the actual configuration from the actual functionalities of its operation. I would rate it a nine out of ten.
If somebody is looking for stability then I recommend this platform, although it depends on whether they want a Data Lake or are looking for analytics. I would rate this solution a nine out of ten.
I suggest to anyone considering this solution to get hands-on experience with the solution, and run some tests and pilots. When evaluating a solution like this one, you must consider the product itself, the support available and how common or popular the product is. I find that if it is a popular product, that means there are a lot of people who know the product well, and it's easy to do work with that particular product.