IBM Db2 Database Reviews

I am an ex IBM employee, and I used to be the brand ambassador for Db2 in Africa. So, I do understand how it works because I've used it with customers. Currently, I am mostly supporting some of the Db2 customers in Kenya.

I am now using version 11.1, but I used version 10.5 for the longest time. 

It has a good feature called pureScale, which is just for scalability. It is a perfect solution for environments where scalability is going to be an issue.

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.

I have been using this solution since 2012. It has been nine years.

It is stable. The 10.5 Fix Pack One was not very stable. We also had Fix Pack 4, also called Cancun Release, which was very stable. As the product has evolved, it is more stable now than it was a couple of years ago.

It is a perfect solution for environments where scalability is going to be an issue. I am supporting two banks. They use Db2 for their core banking system. There are more than 500 users per bank who use this solution every single day.

I have worked with IBM, and I have seen their support teams. They are very passionate about supporting their users. Whenever there is a problem, they have a team that is there 24/7 to ensure that their customers are supported. They are very fast and very technical in solving problems.

I have used SQL Server, IBM Db2, and Oracle Database. Microsoft provides usability. SQL Server is very easy to use and adapt. The only problem is that it only lives within the Microsoft Windows operating system, whereas Db2 is available on Linux, Unix, Windows, and Linux for mainframes. 

When comparing IBM Db2 and Oracle Database, I would go for IBM Db2 because it has complete functionality. A lot of features available in IBM Db2 are not there in Oracle Database. IBM Db2 has time travel queries that are not available in any other solution. From the perspective of a software developer or a database developer, there are more functionalities in IBM Db2. It is more futuristic.

It is very technical to deploy, but once you configure and make it work, it is a perfect solution for an environment where scalability is going to be an issue.

Among Microsoft SQL Server, Oracle, and Db2, Microsoft SQL Server is the cheapest one, and Oracle is the most expensive one. Db2 is in the middle. As compared to SQL Server, its price could go down. It will be good for customers.

I would love to expand its usage in the future. We are looking to migrate the finance industry customers in Africa to Db2, especially from Oracle to Db2. 

I would rate Db2 an eight out of ten.

We are a bank. The banking system uses IBM Db2 Database to save data in the database.

I have found the most valuable feature to be its availability. There is almost no downtime and the performance is very good.

I would like to see some artificial intelligence brought into the solution. Additionally, we need a way to gather some reporting information from the bank.

I have been working with IBM Db2 Database for a year now.

There are no real issues with the overall stability of IBM Db2 Database.

We do not have any problems with scalability. I would say give high marks for scalability.

Technical support is excellent. I would like to see better documentation. We have to speak to a support representative when we can not find the documentation on an issue we are facing.

From a performance perspective, I prefer SAP HANA for performance.

I would recommend IBM Db2 Database as a ten on a scale of one to ten. It is very powerful and responsive. 

It's shipped with another software IBM product called Maximo. I'm using it just as an underline. It is a typical database. I use it as a database container.  

The setup process has become much easier recently. 

It is quite stable.

The solution can scale well. 

I am not heavy into developing in Db2. All my development is in the application itself, not in the Db2. Therefore, it's hard to think about areas it needs to improve in. 

The user interface is not user-friendly. There's a converter tool that is much easier for us in comparison. 

We would like the product to have tutorials and answers to questions and troubleshooting to be easier to find online. It's hard to find the answers you're looking for. 

I need data replication to be much more efficient than what is available in the current version. 

I've used the solution for around three years now. 

The solution is stable. Even if there are a large number of records, the performance stays the same. There are no bugs or glitches and it doesn't crash or freeze. 

We have found the solution to be scalable. If you want to expand it, you can. 

We don't really have individual users. It comes as part of a package and therefore it's hard to say who is using it and who isn't. 

They need better support and better online resources. If I try to Google something to troubleshoot, I cannot find an accessible answer. 

Neutral

The initial setup has recently become easier and more straightforward. A lot of enhancements have happened here. Still, it is a bit complex. 

I am not paying the license for it individually. It's included in the package.

That said, the cost in general could be more reasonable for the package as a whole. 

We did look at other options and found them to be more reasonably priced. 

I'd recommend the solution to others. However, I'd recommend other potential users try to find a cheaper option. I'd rate it overall at a seven out of ten. 

I'm using this solution for a financial network. I make and prepare the databases for analysis.

I'm using version 11.5. There are 1,200 people using this solution in my organization. It's deployed on-premise.

It's very secure.

The command line part of this solution could be much better. Redshift is a lot better. It's easier to work with them. IBM Db2 is a little bit outdated.

I've been using this solution for two years.

It's scalable.

Technical support isn't very helpful when I've had problems.

It's not easy to set up. It takes a long time, especially compared to other solutions.

It's very expensive.

I would rate this solution 6 out of 10.

We are using it for our SAP system.

Db2 Database has given us good results since we have started to use it. We predominantly use IBM hardware, and this is one of the reasons why we started to use Db2 Database. 

Db2 Database has a very good HADR capability. High availability resilience is also good in this solution. It also has pureScale, which allows you to upgrade one node to get very good and high-level resilience. If you are using a database on five nodes, you can take one node down, upgrade that, and let that node up. You can then bring the second node down, upgrade that, and so on.

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.

I have been using this solution for five or six years.

Initially, there were hiccups, but now, it is a robust database. The only limitation that we have found is crash recovery. In terms of bugs, every database will have some bugs that will hit you. I don't see much in terms of bugs in Db2 Database. Whatever known bugs are there, we get those issues.

They are really very good. Overall, if I have to give a rating, I will give them an eight and a half or a nine out of ten. Their response to our requirements is quite good. They have good resources at the technical end. They take us very seriously. It might be because we are one of the largest accounts. I don't know what happens with medium-scale industries or small-scale industries. 

We migrated from Oracle Database to Db2 Database because it was quite a good and cost-effective solution. Oracle Database was coming out to be expensive.

The initial setup was complex altogether. It was complex because we were moving from Oracle Database to Db2 Database. A lot of code changes were required. 

We did not buy it. It came with our hardware without any complimentary maintenance. If I compare Db2 Database with Oracle Database, its price is lower than Oracle Database.

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.

We use the solution as a database for e-commerce applications.

The solution's most valuable feature is scalability.

The platform itself needs improvement. They should develop a containerized version of the solution. In addition, they should include dashboard features as well.

We have been implementing the solution for customers since 2006.

It is quite a stable solution. I rate its stability as an eight.

We have 34 technical users and over 50 end users for the solution. I rate its scalability as an eight.

The solution's technical support team could respond faster.

Neutral

I have used Oracle in the past. In Comparison, IBM provides better performance and scalability features.

The solution's initial setup process has medium complexity. It takes a few days to complete. I rate the process as a seven.

I rate the solution as a seven.

Some customers use it for imaging databases, and others use it for ERP systems.

The most valuable features are the HADR, and it is so simple.

The backup solution lacks flexibility in some situations and could be improved. In addition, the management tools should be improved in the next release.

We have been using this solution for more than five years. We mostly use version 10.5 but sometimes use version 9.7.

It is a stable solution.

It is a scalable solution. 

I rate the technical support an eight out of ten. Our issue with the technical support isn't isolated to IBM Db2 Database, but it is an IBM policy. They try to solve problems remotely, but it is not the same as other products because it takes more time to solve.

The initial setup was easy. I rate the setup an eight out of ten.

The solution has annual licensing, and the costs are reasonable for the product. I rate the pricing a six out of ten.

I rate this solution a seven out of ten. I would recommend this product to customers. Most solutions have some environments requiring an enterprise database, so if a customer uses an IBM solution, the database should be Db2. Some customers may be using SQL Server, and if we have the solution for the Microsoft environment, we will recommend them to another database. But if the proposed solution is AIX or Unix system, we recommend they use the Db2 database on that platform. So it depends on the environment.

We use IBM Db2 Database to monitor the deadlock's thread pool status of a particular DB or the particular process or whatever the corresponding DB instance is. We do this for the customer's requirement.

The most valuable feature of the IBM Db2 Database is security.

 I have been using IBM Db2 Database for two years.

IBM Db2 Database is stable.

I have found IBM Db2 Database scalable.

The technical support can be faster.

I have not used other solutions in this category other than IBM Db2 Database.

The initial setup of the IBM Db2 Database is straightforward. The full implementation took approximately one month.

We did the implementation of the IBM Db2 Database in-house.

I would recommend this solution to others. If some planning is done and things are in place then the solution will work as expected.

I rate IBM Db2 Database an eight out of ten.