DB2

DB2

Customer Verified
DB2

Overview

Reviews

IBM DB2 The Most Powerful Relational Database

9
We were using IBM DB2 as a database to store a huge amount of complex data It's a robust relational database management system (RDBMS). We …
Read full review

Solid Product With Great Potential

6
In our organization, DB2 is being used as a database for our mobile app. We also use it for querying data for business analytics and …
Read full review

Reviewer Pros & Cons

View all pros & cons

Pricing

View all pricing
N/A
Unavailable

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.

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Would you like us to let the vendor know that you want pricing?

1 person want pricing too

Alternatives Pricing

What is Microsoft SQL Server?

Microsoft SQL Server is a relational database.

What is Snowflake?

The Snowflake Cloud Data Platform is the eponymous data warehouse with, from the company in San Mateo, a cloud and SQL based DW that aims to allow users to unify, integrate, analyze, and share previously siloed data in secure, governed, and compliant ways. With it, users can securely access the Data…

Features Scorecard

No scorecards have been submitted for this product yet..

Product Details

What is DB2?

IBM Db2 is a family of data management products, including the Db2 relational database. The products feature AI-powered capabilities to help modernize the management of both structured and unstructured data across on-premises and multicloud environments. By helping to make data simple and accessible, the Db2 family aims to position businesses to pursue the value of AI.

Most of the Db2 family is available on the IBM Cloud Pak® for Data platform, either as an add-on or an included data source service, making virtually all data available across hybrid or multicloud environments to fuel AI applications. It can be used to converge transactional data stores and rapidly derive insights through universal, intelligent querying of data across disparate sources. Cut costs with the multimodel capability that eliminates the need for data replication and migration. To support the user's agility Db2 can be run on any cloud vendor.

DB2 Videos

IBM DB2 Tutorial

Watch IBM Db2 – The AI database

DB2 Integrations

DB2 Technical Details

Deployment TypesOn-premise, SaaS
Operating SystemsWindows, Linux, UNIX
Mobile ApplicationNo

Alternatives

View all alternatives

Frequently Asked Questions

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.

What is DB2's best feature?

Reviewers rate Availability highest, with a score of 10.

Who uses DB2?

The most common users of DB2 are from Enterprises and the Information Technology & Services industry.

Reviews

(1-25 of 33)
Companies can't remove reviews or game the system. Here's why
Valarie Thomas | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
It is very easy to install and get started quickly and the ability to store data in a different location and access it in another location makes it very convenient for our users. Great platform with back-ups and recovery features and the high security for our data is assured when storing on this platform.
Ravi Khunt | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
IBM DB2 on Cloud provides Standard and Enterprise plans with specific configurations, which can user select based on their requirements.
It also provides auto scaling of database size without down-time, which actually almost all users/service providers really needed.

IBM DB2 on Cloud is not suitable for those who don't wants to work with SQL Queries.
Moris Mendez | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Db2 on cloud is a very good way to introduce ourselves into the database environment located in the cloud, since it provides a great level of versatility, flexibility and security, which can translate into a better performance of the productivity of our systems and therefore from our department.

Db2 on Cloud should not be taken lightly as it has a medium level of complexity when installing and configuring its implementation
Rishabh Khanna | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
It is a great product. It can be used by new as well as experienced developers to create a database instance without any assistance from DBA. We are using it with our IoT based ERP system. It can also be used by Analysts who want to build databases from scratch in no time.
Ejaz Hussain | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
We have been using IBM Db2 on Cloud solution for some time now and we absolutely like its features and functionality. This database is more suited for small & medium-level organizations. [It] can be used as a database for web and mobile applications.
Meet Dabhi | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
- Secure data storage
- Easy to manage.
- Autos-scaling Database-Extracting information quickly.
- Provides Reporting services for data analysis.
- Very good availability and performance
- On-demand availability with almost no down-time

- Fewer region options
- Which may impact your performance and compliance requirements depending on what you're doing with the database.
- The performance is okay as long as the volume of queries is not too high.
Jeremias Esperanza | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
[IBM Db2 on Cloud is well suited for its] UI simplicity where you can enter SQL scripts, stored procedures, and user-defined functions in one place. There is no need for a special IDE. SQL scripts can be written in a way they are intended to increase script meaning. Though, you can not administer administration rights as long as you are in a lite account. You cannot fully explain data concurrency and locking because of the limited administration feature in a database instance.
August 05, 2021

DB2 Warehouse

Sathish Palanivel(He/Him) | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
DB2 is better suited for OLTP workloads
It can get better for OLAP workloads
Scaling is flexible, HA and DR options are also good.
Admin will have controls to stop and start warehouse and spark clusters. Replication is another critical element.
Stored Procedure is located in IDAX, some of the useful procs are Decision tree, K-mean clustering, linear regression, Naive Bayes, random sampling, regression tree. SQL's are supported, SQL statements are executed in the database manager.
Score 10 out of 10
Vetted Review
Verified User
Review Source
IBM Db2 provides [the best] solutions for cloud database management with zero [downtime]. It provides auto-scaling based on requirements, for example for [a] specific period of time, [the] number of users could increase, and decrease, [At] that time we can set auto-scaling without affecting database availability. IBM Db2 on Cloud provides [a] console, where we can execute queries on the go. Though it is secure, still It is not suited for those who [have] security reasons like if they don't want to transfer data outside their organization, because your data will be in cloud.
Score 9 out of 10
Vetted Review
Verified User
Review Source
DB2 is the best relational database for a huge amount of data. Whenever we have a lot of tables and we need to join them to get the result, then DB2 is the best as it provides a more powerful SQL dialect than Oracle or MySQL.
Score 8 out of 10
Vetted Review
Verified User
Review Source
IBM offers a good variety of database choices like DB2, MongoDB, Redis, etc. If you want some database to use quickly but don't want to spend time on setting things up from scratch and don't want to spend efforts on daily operations, IBM Cloud Databases would be a good choice.

In our experience, some database service offers more than one URL, so our application needs to handle the failover.
Ankur Varshney | TrustRadius Reviewer
Score 2 out of 10
Vetted Review
Verified User
Review Source
Db2 is not a solution that I recommend. We have a lot of experience and we are not satisfied with the product or the support that we received. Because of the way our environment works, serving branches, it becomes a challenge to satisfy the customers or users.
Jay Padhya | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
A great product - would not shy away at all. It has some great features that makes it easy to read and write. Their on-memory technology for on-prem is good and overall it's user friendly with its approach. I even like the IBM product support team on helping out on our issues. There is massive community support over online bugs and seems like one of my best go to tools for Data Science.
Score 9 out of 10
Vetted Review
Verified User
Review Source
ERP back-end databases and any other supported application that requires high uptime. The database server performs exceptionally well, and it is a more flexible licensing arrangement than Oracle in most circumstances. Easily manageable across multiple platforms and flexible in backup and recovery options.
DB2 is less appropriate if the cost is a primary factor, or if your application lacks adequate support for it. Connectivity is excellent for the first level of support is lacking; high tiers are top-notch.
Score 10 out of 10
Vetted Review
Verified User
Review Source
DB2 for i is well suited for most backbone workloads, especially those that need very high availability. Some customers might use DB2 for i as the main DB serving data and microservices. Others might have entire application stacks running on WebSphere Application Server or even on PHP.
J.R. Bullington | TrustRadius Reviewer
Score 3 out of 10
Vetted Review
Verified User
Review Source
DB2 is built on mainframe technology. If you are going to be running a mainframe - it's great for your uses. It also integrates well with other IBM products like IBM Datapower and IBM WebSphere.

If you are running websites or web services with it, then maybe it's time to investigate a newer, easier to use technology.
Score 8 out of 10
Vetted Review
Verified User
Review Source
DB2 is very robust on both Z/OS and Linux platforms while it has room for improvement on Unix and Windows platforms. It is very robust and the best feature is the error warning system using SQL - whether it is a simple SQL or complex SQL. It can be used in remote locations over LAN and hence a centralized database would be sufficient.
Score 8 out of 10
Vetted Review
Verified User
Review Source
It's probably more common in the financial and government sectors. Given that user base, it's nice to have common customers. Given that development tools are a little lacking, shops with lots of outsourced development talent might want to think about it.