DB2 LUW Review
December 18, 2015

DB2 LUW Review

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

Overall Satisfaction with DB2

We use DB2 as one of the backend databases for both internal and customer facing applications at Dealertrack. It does not address a business problem as such, rather using DB2 provides a stable, fast and feature full database to store data. The DB2 database platform provides recoverability, uptime and good performance for the applications using it.
  • High level of query fulfillment. One of our applications uses the DB2 database to serve up about 16k to 20k queries per sec at peak, the majority of which execute in less than a few microseconds.
  • Stability. We use a PureScale based, 4 compute node implementation for DB2 and this allows for high uptime. If a node fails, the remaining nodes seamlessly take up the load.
  • Some of DB2 system management tasks can be a bit cumbersome.
  • Rather than adding new features, it would be much better to enhance and expand some of the existing features.
  • Mostly positive impact. The current company started out with using MySQL as their database engine, but once their customer base and the resulting volume of data grew, moving over to DB2 increased their capacity for throughput dramatically.
I have managed Oracle databases too and in my opinion both the database platforms perform about equally. We mostly chose DB2 because we had existing resources familiar with DB2 and the DB2 platform was generally cheaper due to the ability to negotiate cheaper yearly license deals.
DB2 is quite good at generalized work load as well as for OLAP/Batch and online/TXN based workloads. On the other hand DB2 is not well suited for workloads specific to specialized tasks such as document repositories or key/value repositories.