1. Home
  2. Relational Databases
  3. Db2 Reviews
  4. User Review of Db2
Db2 a powerhouse for Data warehouses
December 14, 2022

Db2 a powerhouse for Data warehouses

Bhanu Taneja | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Software Version

Db2 on-premise

Overall Satisfaction with Db2

We are using Db2 for very critical applications where we need high availability and robustness. We are a retail and online business, biggest in Australia so the application demands a backend database which is able to handle such load and data. Using Db2 we are able to provide customers better satisfaction while shopping.
  • Handle huge data
  • Robust with big data
  • Huge range of application compatibilities
  • Easier than others to administer issues and performance bottlenecks.
  • Ability to restore tables from backups
  • Availability of Db2 on public clouds other than IBM
  • Higher DB performance
  • Less outages so better availability
  • Data security.
The best thing about Db2 is its scalability. It can be used for small applications in parallel to the bigger applications as each DB is independent of each other. If the requirement increases in future it can be easily scaled as per requirements.
There are a number of High Availability options which we can use with DB2. DB2 has its own excellent High Availability feature built in HADR which is best for various scenarios. If the application demands OS based then can be paired with PowerHA clusters.
MS SQL is different architecturally than Db2 so applications are different.

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?

I wasn't involved with the selection/purchase process

Did implementation of Db2 go as expected?

Yes

Would you buy Db2 again?

Yes

If the application is based on data warehousing then Db2 would be the best choice to opt for as over more than a decade of my working with Db2 I have found it extremely robust in DW's. It has also performed exceptionally well in case of OLTP databases.