IBM Db2: A Powerful and Reliable DB Management Solution
February 13, 2024

IBM Db2: A Powerful and Reliable DB Management Solution

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Software Version

Db2 on cloud

Overall Satisfaction with Db2

IBM Db2 is a highly scalable, secure, and reliable database management system. It has capabilities such as advanced query optimization and efficient resource management. The biggest problem that my company faces with third-party logistics is that every movement of every shipment is captured. And for that, we require a reliable and efficient database management system. This is where Db2 comes in. Various projects like landing profiles, weak links capturing in a logistics network, etc. are all dependent on Db2. All the Power BI dashboards are also linked with Db2 for real-time accurate KPIs visibility.
  • It's capable of handling large volumes of data, as in our case, every shipment's information.
  • It provides advanced query optimization, enabling quick response and real-time visibility via dashboards.
  • It has easy integration with other IBM products.
  • The biggest challenge is to identify the correct configuration as per the business use case. There should be some sort of AI help for the same.
  • Difficult to use for new users. There should be better training modules available.
  • Requires huge investments. They should have more plans for smaller organizations.
  • Most are positive impacts as per our requirement. We now have really quick real-time visibility on KPIs.
  • We no longer have to worry about scalability issues as the demand increases.
  • We don't have to worry anymore about integration with existing solutions.
  • The negative impact is in terms of the number of people being able to efficiently use the service. Better training modules should be developed.
In terms of scalability, I would give Db2 full marks. In our company, almost every department is utilizing the outputs generated via dashboards for use cases such as manpower planning, scheduling, and routing. This is all has been made possible because of the advanced query optimization capabilities of Db2 which in turn leads to quick response speed.
So far in terms of availability, we have not faced many issues. The only issue has been a bit with getting customer support from IBM, that was also only one incident when we were facing authorization issues, or that I have deducted one mark. Other than that, we have not faced any such issues as application errors or unplanned outages.
I have experience with the above-mentioned similar products but mainly with MySQL. In terms of speed and query optimization capabilities, Db2 is far ahead in comparison to MySQL. Because of various issues like scalability, multiple departments hitting DB together causing failures, etc., we decided to switch to Db2. In terms of data security also, we were facing a number of issues with MySQL which is not the case with Db2.

Do you think Db2 delivers good value for the price?

Yes

Are you happy with Db2's feature set?

Yes

Did Db2 live up to sales and marketing promises?

Yes

Did implementation of Db2 go as expected?

Yes

Would you buy Db2 again?

Yes

MongoDB, Amazon Relational Database Service (RDS)
For organizations having huge data volumes, it is highly recommended to go for Db2 while in the case of smaller organizations, simpler solutions should work just fine. In my company, with capturing every shipment journey, the data volume generated exceeded the limit of simpler solutions, hence the optimal choice was to go for Db2 for various use cases involving ML/AI projects and visual KPIs visibility dashboards. Almost all our projects are dependent on Db2's quick response capability.