TrustRadius: an HG Insights company

Db2

Score8.6 out of 10

273 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 is great for big organisation

Incentivized
Klaudiusz Konieczka
Director, Mainframe System Programming, MF Optimize Technical Services in Engineering at Ensono LP (1001-5000 employees employees)

Use Cases and Deployment Scope

In our organization, we use Db2 To process huge amount of data in short time. We need to have it always current, without any delays. We need to have also secure setup and resiliency on both hw and software

Pros

  • store all critical data
  • make them available
  • make them secure

Cons

  • easier to maintenance
  • less ipl
  • easier to implement pervasive encryption

Return on Investment

  • easy to go through audits
  • good, stable resilient environment

Alternatives Considered

IBM z/OS

Other Software Used

IBM CICS Transaction Server

Db2 the BEST RDBMS

Incentivized
Verified User
Advisor in Information Technology (10,001+ employees employees)

Use Cases and Deployment Scope

Db2 is our backbone to our IT Infrastructure as we have all our Corporate and Client data in Db2 on Mainframe. Db2 perfectly address the business problems of need of keeping data available 24X7, in a secure way, be self resilient and wonderful Business value insights from Large data pool. Scope of our Use case is to make use of Db2 for specific Business purposes as Relational Database Management System

Pros

  • Resilience - Db2 for z/OS 13 has capacity to be self resilient. Example in case if abends and it is brought up it has capability to resolve the issue which caused the abend in certain cases
  • Security - Db2 for z/OS 13 has updated features like profile etc to meet Security Baselines
  • Business Insights - Db2 supports many means of getting valuable Business insights from the huge- data

Cons

  • Allow use of Pass tickets
  • Allow Online indexes reorg
  • Allow more active logs pairs

Return on Investment

  • Time savings from automating
  • Improved compliance
  • Increased uptime

Alternatives Considered

Broadcom Database Management for DB2 for z/OS

Other Software Used

IBM CICS Transaction Server, IBM WebSphere Hybrid Edition, IBM z/OS

Db2 zOS

Incentivized
Verified User
Manager in Information Technology (1001-5000 employees employees)

Use Cases and Deployment Scope

Primary database for trading application. Selected due to its ability to process thousands of transactions and their associated updates.

Pros

  • Process large amounts of updates
  • Backup and recovery
  • Abend protection

Cons

  • Installation, particularly on z
  • Easier to use graphical interfaces
  • Easier and better reporting in the tool to avoid needing ISV software

Return on Investment

  • Db2 on z saves money as compared to duplicating the throughput with another platform

Other Software Used

IBM z/OS, IBM MQ, BMC AMI Ops

Db2 Review

Incentivized
Verified User
Engineer in Engineering (501-1000 employees employees)

Use Cases and Deployment Scope

We tore the vast majority of our data on Db2 and is handled with hundreds of developers across multiple different teams thousands of times throughout the day. This product has been fantastic for handling our vast amounts of data for the healthcare industry and allows for easy to query tables. We trust Db2 to handle PHI of millions of people throughout Alabama and multiple other states and couldn't be happier!

Pros

  • Store data relating to Pseudo Claims
  • Allow for easy to query tables

Cons

  • More mainframe support

Return on Investment

  • Easy to query tables have cut down our time a significant amount

Other Software Used

IBM DataStage

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

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