Db2

Score8.6 out of 10

273 Reviews and Ratings

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

Screenshot of Db2 - Data sharing

#1 most frequent

Professional, Scientific, and Technical Services

26.6%

2,533 installations of 9,536

“It works smoothly with automation platforms like RPA and helps with replication too.”
— Founder & CEO, ENCYPHERS (11-50 employees)

#2 most frequent

Finance and Insurance

16.1%

1,531 installations of 9,536

“In our organization, We use IBM Db2 for database storage and use Db2 for our audit DB.”
— Software Dev, Kemper (5001-10,000 employees)

#3 most frequent

Manufacturing

10.2%

970 installations of 9,536

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

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

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

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

Microsoft SQL Server

Google Cloud SQL

Oracle Database

Db2

What is Db2?

Categories & Use Cases

Media

Most Frequent Users

Professional, Scientific, and Technical Services

Finance and Insurance

Manufacturing

Reviews

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Alternatives Considered

Other Software Used

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Alternatives Considered

Other Software Used

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Alternatives Considered

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Alternatives Considered

Other Software Used

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Other Software Used

Related Products