1. Home
  2. Relational Databases
  3. Db2 Reviews
  4. User Review of Db2
Highly Available and Scalable Relational Database
February 13, 2024

Highly Available and Scalable Relational Database

Rao Tahir | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Software Version

Db2 on-premise

Overall Satisfaction with Db2

It can be used in both ways with or without relational concepts which helped with the current requirement of our business module where we need to be able to store data of both nature, structured and unstructured for us to help minimize the data loss which is incredibly sensitive and important for the business growth and fulfilling product needs.
  • XML structured data storage
  • Relational data storage
  • Materialized query table
  • Online backups need to be taken only in an offline environment which is quite troublesome because you don't always have the option to go offline.
  • Extensibility for buffer pool size in case of large data sets sometimes some tables could need more size for storing which is not possible at the moment.
  • Could be a lot more handy if they could introduce temporal tables like the ones in ms SQL.
  • Data consistency
  • Data loss prevention
  • Data integrity
In the sense of scalability, it is way better at handling different data types than SQL and it has great scalability in terms of both on-premises and cloud-based. The best feature of its scalability would be its ability to partition data across different servers which is an amazing functionality that could help in very tight situations.
It is very robust, quite flexible, and always improving in terms of becoming more efficient. However, one downside that I have noticed is that to use its maximum potential, one needs to acquire a business license. Additionally, it is necessary to use IBM hardware, as using other hardware can cause conflicts.

Do you think Db2 delivers good value for the price?

Not sure

Are you happy with Db2's feature set?

Yes

Did Db2 live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of Db2 go as expected?

Yes

Would you buy Db2 again?

Yes

it is well-suited for mid-sized multipurpose data storage which is very likely in some integrated platform that requires multiple formats of data fetching and storage for pushing or pulling into or from the external or internal system.