DB2 Warehouse
August 05, 2021

DB2 Warehouse

Sathish Palanivel(He/Him) | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Software Version

Db2 Warehouse on-premise

Overall Satisfaction with DB2

We are using In memory BLU processing and in-database analytics, able to scale through MPP architecture. The flexibility of being in the cloud without giving up on control, suitable for the hybrid model. Security features can provide row and column level controls. For fine-grained access control to a data warehouse, we can create and use our own user-defined user roles to accommodate the special needs of our organization. Admin should be able to manage how access controls for the organization have to be managed. An audit policy is there to enable monitor unwanted access. Encryption is possible using the master key in DB2 Data Warehouse. DB2 warehouse also has integrated Spark.
  • ACID compliant
  • Good for transaction like work load
  • Suitable for continuous small amount of loads
  • handling more volume use changes
  • concurrent users
Db2 Warehouse provided more flexibility than another tool in the market for a hybrid solution. The ability to integrate with Oracle also was one of the useful features for our business case.

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

DB2 is better suited for OLTP workloads
It can get better for OLAP workloads
Scaling is flexible, HA and DR options are also good.
Admin will have controls to stop and start warehouse and spark clusters. Replication is another critical element.
Stored Procedure is located in IDAX, some of the useful procs are Decision tree, K-mean clustering, linear regression, Naive Bayes, random sampling, regression tree. SQL's are supported, SQL statements are executed in the database manager.