Db2 LUW a DB for performance security and resiliency
October 09, 2025

Db2 LUW a DB for performance security and resiliency

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

Software Version

Db2 on-premise

Overall Satisfaction with Db2

Db2 is used as the main database technology for our most critical products. Aspects like data replication, performance, security and high availability are crucial for us. All features that Db2 manages to address very well

Pros

  • Optimizer performance
  • Data Replication
  • High availability
  • Snapshot-based backups

Cons

  • Lifecycle-management
  • Security auditing
  • Data migration
  • Negative: Difficult and manual deployment
  • Negative: Missing assistants from common monitoring metrics
  • Positive: Stability
  • Positive: Performance
  • Positive: Resiliency and high availability (HADR)
  • Positive: Data Replication (Q-Rep)
  • Positive: Interaction with storage subsystems for backups (TSM, SVC)
  • Positive: Gigantic monitoring features in the form of table functions
HADR, Q-Replication, STMM, Optimizer, ACS (Advanced Copy Services), Online Runstats, Online Reorgs
Live migrations between architectures and encodings
Superior in almost anyway except learning curve, marketing and deployment

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

Db2 is an extremely performant database, which enormous possibilities for configuration and ideal for deploying in heterogeneous but critical environments. Features like HADR, Q-Replication and ACS (Advanced Copy Services) make it possible to handle critical applications under constant load pressure while always maintaining high resiliency

Db2 Feature Ratings

ACID compliance
10
Database monitoring
7
Database locking
8
Encryption
7
Disaster recovery
10
Flexible deployment
5
Multiple datatypes
9

Comments

More Reviews of Db2