#1 most frequent
United States of America
45.1%4,247 installations of 9,419
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
Who Buys & Uses Db2
#2 most frequent
India
5.4%509 installations of 9,419
#3 most frequent
Canada
4.3%408 installations of 9,419
Db2 LUW a DB for performance security and resiliency
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
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
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
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
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.
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
