Db2

Score8.6 out of 10

231 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

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ß

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

Vikas Kumar

Principal Consultant in Information Technology at Infosys Limited (10,001+ employees employees)

Use Cases and Deployment Scope

IBM Db2 is used as a database for many of OMS projects where the backend is IBM Db2

Pros

Performance
Stability
Ease of use

Cons

Auto tuning of DB storage
Shorter downtime for maintenance

Return on Investment

Overall cost of ownership is lesser comparable to other competitors
IBM support is great

Alternatives Considered

IBM Cognos Analytics

Other Software Used

IBM Sterling Order Management, IBM Store Engagement

Microsoft SQL Server

Google Cloud SQL

Oracle Database

Db2

Connect with IBM

Connect with IBM