Db2

Score8.6 out of 10

274 Reviews and Ratings

Get a Demo

Db2

Get a Demo

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

1 / 3

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

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

Daniel Groß View profile

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

Ronald Heerema View 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

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

Microsoft SQL Server

Google Cloud SQL

Oracle Database

Db2

Connect with IBM

Connect with IBM