Please share with the community what you think needs improvement with IBM Db2 Database.
What are its weaknesses? What would you like to see changed in a future version?
Integration with other services could use some improvement. Currently, we are using Informatica ETL (Extract, Transform and Load) and the data is not loading as expected between the Db2 database and Informatica. Our goal is to eventually migrate the data to Azure servers and evaluate how it will perform. Currently, we are doing a POC (Proof of Concept) on this migration, but the second step cannot be completed without a dependable data load.
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.
The price should be lower.
Because this solution is a big data database only dedicated to the application server, it is very difficult for us to assess areas of improvement. We use the database, so we don't have any other requirements or need to use it in any other way. The licensing fees can be reduced. While we don't see the breakdown, we know that IBM licenses for the backup system are very expensive.
The ease of use, or ease of management, could be improved. There are many improvements all the time on the solution. There is no one thing that I would mention. IBM invests a lot of money to improve the tool and maintain it. There are improvements all the time happening in different areas.
IBM just came out with new hardware in September, so they are getting ready for the cloud. If they can push through with all those features they're talking about, I think they have a good product lined up. Right now, the solution needs to have end-to-end encryption, to be cloud-ready, to have native support for Linux, and built-in data scientist workbenches. These are promised to us in the new release, and I hope that happens. End-to-end encryption specifically is something the solution needs to have in the next release.
We would like to see a web-based interface for this solution, as it would help to improve visibility. It would be helpful to have more querying tools and more development tools for us to work easily with Microsoft. For example, ODBC drivers would make work easier for our development team.
I don't have a general opinion about how they can improve this product. The performance could be improved.
I would like to see better support for advanced analytics.
It would be nice if it was easily available on all platforms because nowadays, it is not there as a general database.