We just raised a $30M Series A: Read our story
2018-10-24T14:07:00Z

What advice do you have for others considering IBM Db2 Database?

10

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?

ITCS user
Guest
2020 Answers

author avatar
Top 5Real User

I would recommend this solution to others. I rate IBM Db2 Database a nine out of ten.

2021-10-11T19:11:17Z
author avatar
Top 20Real User

We're not a software provider, we're an end-user. When you start talking about Db2 on Linux and Unix, the current version is version 17.3 or 17.4. The IBM i, the versioning doesn't work the same way, it has to do with the operating system levels that you're running, as to which version of Db2 you're in. It's integrated in with the system, operating system. It's not actually an independent version of Db2, it's integrated in with the operating system on that platform. Db2 is different in our architectural world than standalone Db2. It's not like standing up an instance of Db2 would be the same as it would in Oracle, or a Microsoft SQL instance, on a Windows 10 server or a Windows 2008 server or whatever it may be. It's the fact that it's bundled in with the software, with the operating system, with the hardware, when you buy that machine. Since it's all bundled inside of it, we're having to go out and independently do things with it. It's inherent, it's bundled. It's probably not the best example of Db2, because even when IBM goes out and talks about Db2, they talk about Db2 zOS, which is the Linux Unix installation. You very rarely see them talking about the IBM i installations. In fact, in even the documentation I was reading in the comparisons, it was comparing the Linux Unix IBM Db2 against Oracle, and against the Microsoft SQL Server. If you're looking at an alternative to Oracle or to Microsoft SQL server, look at Db2, and then once you're in Db2's world, take a look at IBM i against the IBM Z, and compare the two of them. The stigma that the IBM i has, is that RPG language barrier. Since that barrier has now been removed, you can do everything that you can do on the IBM Z as well. The stability of the platform is what people need to look at. There is a trade-off of uptime and never been hacked operating system against versus Microsoft and Oracle in the news every single day. Microsoft cloud just made a comment in the last 48, 72 hours about their cloud services being hacked. That's just something you do not see happening with that IBM series architecture. Since Db2 rides inside of very secure architecture, people should probably give it a very good, hard look, compared to Oracle and Microsoft, and say, "Hey it might not be as popular. It might not be as big a deal, but if my data is more secure, and I don't have downtime and I have performance, is it something that we should be looking at?" I've been at companies that have looked to move off of that, and when they've looked at the Oracle solution, and, no matter how you power it, and no matter how you scale it, whether you scale it up or you scale it wide, the performance is simply just not there compared to what the IBM systems offer through their Db2, whether it be the i or the Z through what they offer internally in their performance capabilities. Your iOS, your throughputs, your performance cycles, you cannot touch it with Microsoft or with Oracle scalability-wise. That is far and away the most scalable systems and the highest performing systems of the set of them. I'd rate the solution at a ten out of ten.

2021-08-30T15:48:08Z
author avatar
Top 20Real User

I rate this solution an eight out of 10.

2021-07-20T11:10:07Z
author avatar
Top 5LeaderboardReal User

I would recommend this solution to others. I rate IBM Db2 Database an eight out of ten.

2021-06-04T13:09:46Z
author avatar
Top 5Real User

I would recommend this solution to others if they have the proper application, otherwise, it might not fulfil their needs. We plan on using the solution in the future. I rate IBM Db2 Database a seven out of ten.

2021-04-14T07:01:01Z
author avatar
Top 20Real User

I would recommend Db2 Database to others because, as time passed, they have made a lot of changes, such as crash recovery. The time of crash recovery is reduced by almost 60% to 70%. Db2 Database also has Db2 BLU, which actually is in-memory. We have not explored this particular feature, but I would recommend others to explore it. With Db2 BLU, it becomes equivalent to HANA. We are seeing it being used a lot in large banks etc. Among Oracle, Db2, and SQL databases, I would rate Oracle first, Db2 second, and SQL third. I personally believe Oracle is the most robust database. Db2 is the second robust database. I would rate Db2 Database an eight out of ten.

2020-10-29T01:27:27Z
author avatar
Top 20MSP

On a scale from one to ten (where one is the worst and ten is the best), I would rate IBM Db2 Database as a seven-out-of-ten. Most of the time recommending Db2 is harder than recommending Oracle because of the situation in our country. Whenever I propose Db2 to a customer, the customer will ask what they need to have to develop applications on Db2. I have to say to them that they need to have a Java developer to work on that. If the customer already has some Oracle databases, this makes introducing Db2 even more difficult because they already have the resources for Oracle development. Suggesting Db2 is difficult in our country because most of the people already have Oracle now. So suggesting Db2 is difficult because development on Db2 is not as easy as Oracle and finding the resources to work with it is not as easy. The question we have to answer all the time is who will do the development if the customer does not have a Java developer resource already.

2020-09-15T11:13:33Z
author avatar
Real User

In summary, this is a good solution and one that I recommend. However, there is room for improvement in terms of performance and scalability. I would rate this solution an eight out of ten.

2020-09-02T06:45:40Z
author avatar
Real User

The suitability of Db2 depends on your environment and needs. If you want to implement an on-premises monolithic application that can handle all of your transaction management then Db2 is a good choice. The technical support is very good, and if you have multiple data centers, the applications are also good. I would rate this solution a seven out of ten.

2020-07-05T09:38:00Z
author avatar
Top 5Real User

We're currently IBM partners. I use the solution extensively. I'd like other companies to know it's quite easy to set up and maintain. If they are looking for something fairly easy to jump into, this may be it. I'd rate the solution seven out of ten.

2020-06-18T05:17:54Z
author avatar
Top 20Real User

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.

2020-03-16T06:56:00Z
author avatar
Top 10LeaderboardReal User

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.

2020-02-26T05:55:00Z
author avatar
Top 20MSP

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.

2019-12-22T06:32:00Z
author avatar
Top 20Real User

This is a robust and stable product but it's expensive. I would rate this solution an eight out of ten.

2019-12-19T06:32:00Z
author avatar
Real User

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.

2019-11-27T05:42:00Z
author avatar
Top 20Real User

I'd rate the solution a six out of ten.

2019-10-24T04:52:00Z
author avatar
Real User

I don't think that we will be changing solutions within the next year. I would rate this solution a seven out of ten.

2019-10-15T05:01:00Z
author avatar
Consultant

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.

2019-08-26T06:42:00Z
author avatar
Consultant

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.

2019-08-08T07:02:00Z
author avatar
Real User

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.

2018-10-24T14:07:00Z
Learn what your peers think about IBM Db2 Database. Get advice and tips from experienced pros sharing their opinions. Updated: November 2021.
552,305 professionals have used our research since 2012.