IBM Db2 Database Room for Improvement
Mainframe Technical Manager/Service Integration Lead at a tech services company with 10,001+ employees
The good thing is that there are improvements coming with later function levels for the z/OS Db2. I'd like it if, with the operating system that we've got, z/OS, on the mainframe, it would allow us to refresh the hardware to run Linux dockers on the mainframe. This means this might give us opportunities for different ways of coming into the Db2 environment in the future. We just want a bit more integration with Linux. That said, we are already seeing Linux more readily available on the mainframe environment.
Not only have we got the premium operating systems on OS. We can run LPARs on the same mainframe footprint that is also supporting Linux. This is what has improved and made the mainframe environment more competitive.
We're also looking at AI for Db2 as well, and machine learning for the future. We know that AI has come out, that we're going to get that, and we're going to evaluate that product next year for Db2.
That said, I haven't got any real complaints about Db2 on the mainframe. For the most part, a lot of the problems we have nowadays are to do with communication between the various teams that you would class as stakeholders.
Senior Systems Architect/Analyst/Developer at a logistics company with 1,001-5,000 employees
It's going to be a much smaller marketplace for this product, and most significantly, IBM doesn't target marketing to that marketplace. Their view of it is they're maintaining it, they're continuing to upgrade it, they're continuing to grow it, however, they don't go out and try and sell that as an architectural solution the way they do Linux and Unix. That's because once you get inside of the IBM architecture, up until about six or eight years ago, it was not open source. You were tied to the development language of either COBOL or the development language of RPG if you wanted to develop on that platform.
Now, it now supports Java and PHP, and it does open source, but for those reasons, IBM was never looking to market or push that as a viable solution. They didn't push the IBM i as a direct competitor to Oracle, they pushed their Linux Unix versions of it, their IBM Z series against Oracle and SQL server, as it's a more direct head-to-head comparison. The IBM i architecture is the one-off if you will. You're not going to see a lot of people looking at it.
Senior System Analyst at Thakral
One thing that is a little bit difficult for me — other than when using Oracle — is creating database replication with Db2. It is not so easy. That feature could be improved.
Another thing is that if part of the environment in Db2 goes down, I have to restore all of it. That is something that is just in the environment for the Db2 relational database. The restoration is very difficult because every node has internal storage. If one node is corrupted all have to get restored.
If you compare Db2 to Oracle, both are enterprise-class. However, the development tools for Db2 are not as good. For example, if I want to develop an application in Db2, I have to use Java. That is not so easy because someone has to know the Java platform and a few other things to develop an application on Db2. But the difference is that if you choose to use Oracle there are some tools like Oracle Developers Suite that you can use to develop applications. It is very easy and very straightforward to develop an application in Oracle because of the development tools. It is harder when using Db2 by comparison.
There are some things that are not in Db2. I have to do more to develop an application. Some things are easy to do with Db2 development. Like if I have an application where there will be three or four tables. I can do that with Db2, or I have to do it with other Java development tools. That is the catch: for most of the people who know Java, this development is easy for them. But those who do not know Java can have a very hard time. In that sense, IBM should work on that aspect of their product to make it easy to develop applications. They can do this by providing users with a development suite. If they do that, then I think Db2 has the potential to grow more in our market.
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.View full review »
Microsoft SQL Server is comparatively very simple to use. I wish IBM would move towards making Db2 easy to use for both basic and advanced users. This is where I see room for advancement. Db2 is also more expensive than Microsoft SQL Server, and its price can be reduced.
The replication feature needs to be there in Db2. Microsoft provides similar functionality in SQL Server. IBM also has similar functionality, but it exists in a different product. So, to have the replication ability, you have to buy a different product. It makes sense to have this functionality within Db2 instead of a different product. It will also be helpful in terms of competition.
In Africa, the problem for Db2 is competition. Oracle Database and Microsoft SQL Server have been in this market for a very long time. These companies have built the ecosystem and the brand within this market for a very long time. So, they are very popular with users. Db2 or IBM came a little later in the game, and that's where the problem lies. They also don't do a lot of marketing for it, which is also a problem.View full review »
Global Infrastructure service manager at a manufacturing company with 10,001+ employees
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.View full review »
The solution could improve the centralization aspect of the tools.
It would be ideal if the solution offered backup functionality. Many similar tools already do, which means Db2 is somewhat behind the curve in terms of what a customer might expect from it.View full review »
System Administrator at a tech services company with 51-200 employees
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.View full review »
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.View full review »
Solutions Architect at a financial services firm with 10,001+ employees
We need to have a cloud-based version of this database.
It would be helpful to have a hybrid data storage facility that includes NoSQL technologies.View full review »
They should simplify the management of Db2 as a relational database system. There should be the simplification of management. This is probably one of the most important asks for being successful in the future.
They should add AI support for performance improvements for application and system performance and tuning management. AI is a very deep and complex product. There are thousands of parameters, and it is very hard to do it manually. So, I would suggest developing an AI system to do the monitoring, tuning, and performance improvements.View full review »
I think they need to improve the GUI and I'd like to see more integration with other platforms.
If you have a project involving several platforms or databases it's the integration with other products that's crucial. Db2 has this capability but sometimes there are issues and you have to contact support to get things fixed.
They haven't done extensive testing with integration; they'll often send you to third parties. It often means that you have to purchase additional products in order to integrate with other platforms and that's an additional cost.
The price should be lower.View full review »
Domain architect at a financial services firm with 10,001+ employees
The solution could be more modern and have updated database technology. This would allow it to work with modern applications a lot more seamlessly. You will find that there are other better-suited databases where you can deal with more modern type applications.
In the future, they can improve by being closely aligned with the next generation of application that are arriving or that will be developed.View full review »
CEO at a tech services company with 51-200 employees
The capabilities of this solution could improve.View full review »
IT Developer at a financial services firm with 10,001+ employees
The solution could improve by providing more integration.View full review »
Senior Manager of MIS at Fountain Set
Performance is something that can be improved with DB2.
We have had issues with respect to scalability.
The usability can be simplified.View full review »