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?