Db2 is processing high workload and with high availability for our business.
December 14, 2022

Db2 is processing high workload and with high availability for our business.

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

Software Version

Db2 on-premise

Overall Satisfaction with Db2

DB2 HADR feature is widely used in our applications as continuous availability is utmost important for the business.
As finance institution we have high workload of transactions which cannot have downtime and HADR feature meets our goal.

Pros

  • High availability of mission critical business application using HADR.
  • During upgrade of OS or Db2, pretty much seamless upgrade is done.
  • Overall performance is great despite of our secondary node is remotely located.

Cons

  • Documentation is sometime unclear or confusing.
  • Would be good idea if we can estimate the time needed for index rebuild to complete.
  • Db2 primary should propagate all configs (DBM, DB, Registry) to standby automatically.
  • Has reduced the downtime or outages due to HADR features which we lagged earlier.
  • No manual intervention needed in most situation for us. IN worst case TSA does automatic failover so its transparent for the apps.
  • LOB support is little bit problem for us now which we hope will have some improvement in product in future.
Pretty much our organization's critical applications are based on HADR functionality and so far other than smaller events we didn't have anything severe yet. Its widely used. We also like the simplicity of monitoring in HADR which helps us to understand the status in efficient way.
As noted in previous question, we didnt have any severe outage so far but we do spend good amount of time in monitoring the health of HADR and keeping fixpacks updated so we dont met any defects or so.
Well, it was business decision before I joined the company but its mostly based on usability, cost, performance and availability.

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

We needed to take backup of DB which is on remote location which is standby but currently HADR doesnt support backup of standby so Db2 was not well suited there and we ended up using storage level backup.

Comments

More Reviews of Db2

  1. Home
  2. Relational Databases
  3. Db2 Reviews
  4. User Review of Db2