TrustRadius: an HG Insights company

Db2

Score8.5 out of 10

230 Reviews and Ratings

Contact

What is Db2?

DB2 is a family of relational database software solutions offered by IBM. It includes standard Db2 and Db2 Warehouse editions, either deployable on-cloud, or on-premise.

Categories & Use Cases

Media

Screenshot of Db2 - Data sharing
Screenshot of Db2 - Machine Learning
Screenshot of Db2 - Real time insights

1 / 3

Screenshot of Db2 - Data sharing

Reviews

What users are saying about Db2.
View all reviews

Db2 LUW a DB for performance security and resiliency

Incentivized
Miguel Sanjurjo
Lead Expert Managed Platforms & Infrastructure in Information Technology at BITMARCK GmbH (1001-5000 employees employees)

Use Cases and Deployment Scope

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

Return on Investment

  • 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

Alternatives Considered

MariaDB Platform, Oracle Database and PostgreSQL

IBM Db2 for i - the integrationintegrated database

Incentivized
Daniel Groß
Senior Software Engineer in Information Technology at Geis Group (5001-10,000 employees employees)

Use Cases and Deployment Scope

In logistics information makes the difference - knowing exactly what, where, when and how much is crucial. Having that data available in real-time is important and data safety and security are essential. IBM Db2 for i is our central database system for all business critical information. From operations to finance, we store everything in Db2 for i.

Pros

  • Very close to SQL standard
  • Visual Explain
  • Integration of operation system, database and application development

Cons

  • Should catch up with Db2/Z and Db2/LUW

Return on Investment

  • Increased uptime
  • Complete integration
  • Automatic and Visual query optimization

Alternatives Considered

Microsoft SQL Server

Other Software Used

IBM i

Secure scalable and easy to use

Incentivized
Aafaq Sikandar
Founder & CEO in Corporate at ENCYPHERS (11-50 employees employees)

Use Cases and Deployment Scope

I mainly use Db2 for managing large volumes of employee data from multiple sources like ERP and payment software. Db2 is the best tool for integrating with BI tools like PowerBI and Excel and I use it daily for reporting, automations and querying.

Pros

  • easy integration with Db2
  • advanced security features like encryption and user roles, so I don’t worry much about data leaks
  • the Express version is great for small businesses and still works well with all tools

Cons

  • the design part of the view sometimes returns errors while the query works successfully
  • some tasks are complicated
  • sometimes I came across compilation errors

Return on Investment

  • it reduces a lot of manual work since I can automate alerts, updates and daily reports
  • i don’t need extra tools for data comparisons—just views and procedures do the job
  • it’s cost-effective, especially with the Express version that still offers a lot

Other Software Used

Vasion Print, Macrometa, RavenApps

Db2 Rocks

Ronald HeeremaView profile
Architect in Information Technology at Dutch Tax Administration (10,001+ employees employees)

Use Cases and Deployment Scope

We use Db2 as a database under our FileNet Content Management solution and have 1000+ instances running our environment.

Pros

  • Performance
  • Ease of use
  • Good management

Cons

  • Table width

Return on Investment

  • Uptime of a HADR implementation is near 24/7

Other Software Used

IBM FileNet Content Manager

Usability

my favorite product Db2

Incentivized
Juan Garay
especialista de ti in Information Technology at inspira it (11-50 employees employees)

Use Cases and Deployment Scope

It is a robust, high-capacity database that can support high workloads for high-availability scenarios.

es una base de datos robusta de alta capacidad de poder soportar altas Cargas de trabajo para escenarios de alta disponibilidad.

Pros

  • robust
  • robustes

Return on Investment

  • positive experience
  • experiencia positiva

Related Products

Products similar to Db2 that may also meet your needs.
All comparisons
Microsoft SQL Server
CompareLearn more
Google Cloud SQL
CompareLearn more
Oracle Database
CompareLearn more