DB2

DB2

Customer Verified
DB2

Overview

Reviews

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

Great Product, with a Terrible Name

8
This review will be for Db2, which is the distributed version, running on Linux/Unix/Windows. The fact that IBM has a separate product …
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 124)
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
My experience using IBM Db2 on Cloud is very good as retrieving data from the database is very fast and can store large files in the database in an easy way. We are able to store data in a different locations and access it from another different location in an easy and smooth way.
  • Very fast to retrieve data from IBM Db2 on Cloud.
  • Store large files in the database in an easy way.
  • Store data and access it in different locations.
  • Runs and scales well on IBMs power-based platforms.
  • Data recovery and back-ups can be complex to new users.
  • Only runs and scales well on IBM power-based platforms.
  • Can be complex to beginners when migrating XML data.
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
We are using IBM Db2 on Cloud based on our requirements for storing and manipulating data securely and with on-time availability.
IBM Db2 on Cloud provides that service to store and run queries to retrieve and analyze data on the go.
Our clients are using Db2 for analytics and for enterprise applications.
  • Secirity
  • Availability
  • Multiple interface for manipulating data
  • Providing Standard and Enterprise plans based on users requirements.
  • Autoscaling Database
  • Can provide REST APIs for Other technologies as well.
  • Can improve API Documentation that can easily understand new users.
  • If possible, then can be select more availability zones.
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
We are implementing it on a personal level with systems and applications projects under development in order to have a broad first-hand view of the user experience and to be able to recommend the implementation in our department and in the future throughout the organization.
  • Very good availability and performance
  • support for various operating systems
  • Data management is efficient and security is guaranteed, which gives us confidence
  • setup and implementation can be a bit difficult or confusing for less experienced users
  • Response times in customer service could be improved
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 being used by our research and development department. We are working on improving our IoT based ERP system. We want our system to have multiple database integrations so IBM Db2 on Cloud is one of them. We are storing the machine-generated data which comes directly from [the] production site.
  • It is easy to understand
  • It is fully managed and highly available
  • It provides easy data migration
  • They should work on improving UI part
  • Documentation can be more helpful if they will add best practices section
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 as our development & testing database which is used across different projects spanning multiple clients. Our development teams make use of this fully managed database as a service solution to store critical test data and also to fetch data for multiple applications.
IBM Db2 on Cloud is a very robust and versatile solution [that] doesn't need any prior hard core db knowledge to use it, so this was a clear choice when deciding to opt for a seamless database solution.
  • Extremely easy data migration
  • Intuitive UI & easy to learn
  • Availability of auto backup feature
  • High service availability
  • Very less region options
  • Pricing model could be more flexible
  • More product documentation be made available
  • UI could be made more interactive with little bit of enhancement
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
We have integrated IBM Db2 on Cloud based on our project's requirements. It provides one of the best solutions for real-time availability and manipulating of data. It [fulfills] requirement very efficiently for data analysis for application. IBM Db2 on Cloud provides optimized security and storage of data with on-demand availability.
  • Enterprise ready
  • Reliable
  • Cost effective
  • AI ready
  • Pay as you go
  • It provides reach UI for database queries, but also better if it provides rest apis.
  • 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.
- 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
I am using it to teach university students about database fundamentals and how they are deployed in a cloud architecture setting. Relational concepts of a database are taught and applied using the Db2 Cloud lite account. An actual demo of how to import data and run SQL scripts is part of the learning activities.
  • Using the SQL SELECT Statements
  • CRUD operations
  • Running user-defined functions and stored procedures
  • Connection to Visualization Tools (PowerBI, Tableau)
  • Connection to Reporting Tools (JasperSoft)
  • Connection to PHP
[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
We are using In memory BLU processing and in-database analytics, able to scale through MPP architecture. The flexibility of being in the cloud without giving up on control, suitable for the hybrid model. Security features can provide row and column level controls. For fine-grained access control to a data warehouse, we can create and use our own user-defined user roles to accommodate the special needs of our organization. Admin should be able to manage how access controls for the organization have to be managed. An audit policy is there to enable monitor unwanted access. Encryption is possible using the master key in DB2 Data Warehouse. DB2 warehouse also has integrated Spark.
  • ACID compliant
  • Good for transaction like work load
  • Suitable for continuous small amount of loads
  • handling more volume use changes
  • concurrent users
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
We used IBM Db2 on Cloud in one of our projects based on dynamic requirements. Early we were using Microsoft SQL Server for database management and [maintaining] transaction history. We needed one solution that helps us to resolve manual management of storage size and server configuration. We came to a solution and we have integrated IBM Db2 on Cloud to fulfill our requirements.
  • Auto Scaling
  • Optimized performance
  • Import excel or csv file format
  • Availability
  • Price difference in different regions[.]
  • Could provide better Documentation[.]
  • Can optimize performance matrix reports.[.]
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 8 out of 10
Vetted Review
Verified User
Review Source
  • It can be easily scaled up
  • It offers good region support
  • Data is encrypted and secure
  • DB2 web console is not so stable
  • Not able to see long-term DB2 metrics data
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.
December 01, 2021

Reliable cloud database

Score 8 out of 10
Vetted Review
Verified User
Review Source
  • Helps with latency issue.
  • Availability of large number of servers.
  • Improve the debug logs.
  • Improve documentation.
It is well suited for data ingestion and especially when we need third-party support. Also extensively use it in integration and deployment stuff.
Ankur Varshney | TrustRadius Reviewer
Score 2 out of 10
Vetted Review
Verified User
Review Source
This is part of our Enterprise Data Warehouse solution.
  • The performance is okay as long as the volume of queries is not too high.
  • We have been facing some challenges with Db2 when scaling up the operations in terms of availability. It becomes a single point of failure and it pollutes the whole system, leaving us challenges in serving the traffic. This is the reason that we are considering migrating to Oracle.
  • Scalability has been a problem area. We have traffic on the order of gigabytes per second and it impacts our queries and responses a lot. Considering the volume that we have, it manifests itself into a multitude of issues.
  • We have dealt with technical support on several occasions. Whenever we run into issues, the specialist team is involved and the resolution cycle is stretched. We have to rely on make-shift solutions and the issues keep recurring. Ultimately, the product itself has challenges and we are not currently satisfied with the support, either.
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.
Score 9 out of 10
Vetted Review
Verified User
Review Source
We are using DB2 as a primary database with one of our clients to store data generated by the GST software.
  • Reliable and fast
  • Easy to deploy and administer
  • Scalable as per the requirement
  • Micro options can be placed in more user intuitive interface
  • Documentation can be improved to include more information about micro options available in different menus in the UI
DB2 is best suited for the scenarios where you are already using the different products from the IBM ecosystem. It allows for easy integration between different tools.
DB2 is one of the fast, reliable, secure, and robust databases.
The support experience is good. There is room for improvement in terms of the delivery of support services to customers.
Score 6 out of 10
Vetted Review
Verified User
Review Source
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 marketing analytics insights. This is used in multiple departments in the organization. It allows us to generate reports for meeting with investors. It solves the issue of warehousing our customer data.
  • Business Analytics - facilitates data query to generate reports.
  • Integration - can connect with other software.
  • Easy - easy to learn and implement if you know SQL.
  • Database can run faster.
DB2 is suitable for various uses. The big use case is an online database where users can make online queries and generate batch reports.
DB2 provides a satisfactory solution to our business needs. However, we sometimes experience issues with query speed.
I haven't needed to contact the support team.
Jay Padhya | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Currently IBM Db2 on Cloud is used by our Department, and our organization used a multi-vendor database approach so it's not the only database on cloud we have. We are currently storing daily feeds from our car measurements on the Db2 and then pull data for reports.
  • Easy to learn, install and query - great support. IBM is extremely good in support whenever you have any type of questions. You will find no issues on learning the language and installing.
  • Amazing performance on big queries : Never had issues on performance and we have a big chunk of data to pull.
  • UI : the UI can be improved to a great extent. Ideally we would want to see the UI/UX to match with latest trends.
  • Limitation to a 15TB database size for any edition below than ES for on-prem. I am sure Cloud solves it, but falls in the same range as others (sometimes higher), making it maybe not the first one to go to.
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.
Easily the best product support team. :) Whenever we have questions, they have answered those in a timely manner and we like how they go above and beyond to help.
Score 9 out of 10
Vetted Review
Verified User
Review Source
DB2 is used as the foundation of several high-profile business applications, such as ERP and Tax calculation. These applications are critical to the day-to-day operations of the business. We depend on the reliability of the database for these applications. DB2 addresses these problems by being a rock-solid, dependable, manageable, and recoverable platforms for the business.
  • Rock-solid reliability
  • Highly manageable and cross-platform database
  • Application support
  • Lack of marketing by IBM
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
I will be writing about DB2 for i. That is the name for the DB2 version that is tightly integrated with the IBM i operating system. Not to be confused with DB2 LUW (Linux Unix Windows) or DB2 for z/OS. That those three DB products share the name leads to confusion regarding syntaxis, capabilities, and interoperability.

Customers that use IBM i leverage all the features of the DB even when they don't realize it. Since the DB is part of the OS, everything lives there.

A tape drive? an object in a library. A customer record? an object in another library.

This DB engine has decades of code behind it but it still manages to keep up and innovate with new features at each release.

DB2 for i doesn't require as much administration as the other kind of databases since the system has some leeway to auto-tune itself. Even then, what IBM recommends is a Database Engineer and not a DBA, since they don't really administer the DB but work with the developers to ensure optimal performance out of the system.
  • Extremely stable, DB2 for i on POWER Systems has superb uptimes.
  • Great HA/DR capabilities, integrated in the OS and provided by IBM and other vendors.
  • The toolboxes for managing the system via SQL are great.
  • SQL Index Advisor and other tools help you tune the system with automatic reporting.
  • Marketing. Sharing the DB2 name between LUW, z/OS and i (which is a product for another review) is a search engine nightmare.
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.
DB2 for i scales very well. There are solutions to cluster the DB (DB2 Multisystem, is one) but I haven't seen them in our customers.
Rizwan Ali Joo | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Reseller
Review Source
It is used as a Core system database.
  • Easy to manage.
  • Auto backups are available.
  • Always Availablity feature.
  • No downtime.
  • Data movement utilities are missing.
  • Easy migration from on-premises should be there.
  • Migration from other Cloud competition must be available.
Best suited for: Web apps, mobile apps, small/mid-level organizations.
April 03, 2018

DB2 is great for BI

Josh Rice, MBA, ACSP | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
DB2 is being used as the database software for our financial core software. We also use it to query data for business intelligence. This is used by the whole organization and will allow us to pull reports based on requests. The software is easy enough to use for anyone that has SQL experience and I feel like it is responsive and quick.
  • Business intelligence - Allows for querying of the data to create reports
  • Flexibility - It scales based on your need
  • Robust - Can connect with reporting software such Crystal Reports to build even prettier reports.
  • For those unfamiliar with SQL, it will be a sharp learning curve
If you know SQL, you can pull anything out of the DB that you need and format it into a report. If you are not familiar with SQL, you will have a hard time getting the data out. The power of the software really allows you to focus heavily on BI.
It can grow as your company grows. It also plays well with Crystal Reports and other BI software once you create an ODBC connection for the DB. It can be managed with SQL management studio so no extra software is needed for that.
Jose Yohn | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
It's used at the department level, but queries can be run by the whole organization.

  • Front end application database
  • Mixed OLTP-OLAP database
  • Loan IQ Main database (where Loan IQ is the worlds leading software solution for loan servicing)

  • Sturdy and fault tolerant
  • Fast
  • High parametrization
  • Client tools need to be improved.
  • Documentation needs to be improved
When using on a high OLTP database server with half a second response time and in a data warehouse environment, it never depends on database engine but on the DBAs.
Sometimes scalability is searched when not needed.
October 10, 2017

DB2 eats data for Lunch!

Andrew Juarez | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
We use DB2 to run our entire SAP Landscape
  • Minimal administration needed compared to other enterprise database products in the market
  • Performance has been exceptional and improved with every version
  • The reliability of the DB2 engine is probably it's biggest asset
  • The Oracle compatibility feature stopped short of providing a listener type connection so applications could have been agnostic to what database it was running.
I would highly recommend it for SAP and Analytical workloads.
In my experience we have never had any kind of issues with scaling out a solution. The DB2 parameters are easy to modify to make use of additional Memory.
J.R. Bullington | TrustRadius Reviewer
Score 3 out of 10
Vetted Review
Verified User
Review Source
We currently use DB2 as one of our major database platforms across the organization in multiple different capacities. We have it in different environments, use it for testing of new software features, and use it to support legacy software. This software addresses the need to support legacy Java with the technology of a robust mainframe.
  • DB2 maintains itself very well. The Task Scheduler component of DB2 allows for statistics gathering and reorganization of indexes and tables without user interaction or without specific knowledge of cron or Windows Task Scheduler / Scheduled jobs.
  • Its use of ASYNC, NEARSYNC, and SYNC HADR (High Availability Disaster Recovery ) models gives you a range of options for maintaining a very high uptime ratio. Failover from PRIMARY to SECONDARY becomes very easy with just a single command or windowed mouse click.
  • Task Scheduler ( DB2 9.7 and earlier ) allows for jobs to be run within other jobs, and exit and error codes can define what other jobs are run. This allows for ease of maintenance without third party softwares.
  • Tablespace usage and automatic storage help keep your data segmented while at rest, making partitioning easier.
  • Ability to run commands via CLI (Command Line Interface) or via Control Center / Data Studio ( DB2 10.x+) makes administration a breeze.
  • You cannot run multiple secondary nodes or cluster without additional software purchases; in some cases third party tools. This drastically increases your overall capital investment. The only way to accomplish a true HADR scenario is to set up NEARSYNC in one datacenter and do logshipping to another datacenter. Downside: You have to wait for the final log ship to complete before your DB is back up.
  • Licensing is prohibitively expensive! If you are not grandfathered in, IBM licensing for a multi-datacenter, PRIMARY, SECONDARY, and Disaster Recovery (DR) setup can be in the multiple $100,000 range.
  • Data Studio is built on IBM's Rapid Application Development (RAD) tool, built on Eclipse. So the download is in the multi-GB range and it includes a ton of bloatware not needed for your standard database maintenance. Control Center is a simple, powerful tool at a quarter of the disk space.
  • Support for DB2 is very hard to come by without paid IBM support. Even then, opening PMRs does not solve problems as the response time for any PMR is always more than two (2) hours, even for enterprise-level paying customers. They always want the most inane log files that have nothing to do with DB2 or its operation, or they want core dumps during the issue. This becomes useless when the issue is "our database just crashed and you can't get those logs right now because I do not want to replicate the cause!"
  • DB2's SQL syntax, while ANSI in CRUD opertaions, is different than Oracle. PostgreSQL, MySQL, and even MS SQL. One must become accustomed to a different syntax for LIMITs, cursors, record counting, stored procedures, user-defined functions, and even table / index creation or altering.
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.
You have to be well versed in using the technology, not only from a GUI interface but from a command line interface to successfully use this software to its fullest.
Score 8 out of 10
Vetted Review
Verified User
Review Source
DB2 is the primary relational database being used in our organization both on z/OS and linux platforms - it is used across the entire organization and is being used to store information on transactions in financial, customer, purchasing environments
  • Is platform specific to Z/OS, Linux, Unix and hence can be leveraged in a customized manner
  • Error handling is the most important feature with warnings
  • Very robust database performance in the SQL schema
  • Allows shared access to the database using LAN in remote branch offices
  • DB2 for Unix has definite room for improvement when compared to competition
  • GUI can be much better than what it is now
  • Data base engine can be faster
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
This review will be for Db2, which is the distributed version, running on Linux/Unix/Windows. The fact that IBM has a separate product called Db2 (for z/os) is totally unfortunate and extremely confusing. We run Db2 off zLinux guests, which are virtualized off our mainframe. These databases support a variety of applications, the most important being that it handles each and every card swipe that is done by one of our members. This is thousands per minute, 24/7. We also use Db2 as a repository for a few applications, and as a gateway between the mainframe and our legacy Oracle databases. This portion is called Federation Server.
  • Simplicity. It's way easier to maintain and administer than its red counterpart.
  • Avoids the terrible GUI trap of its contemporary from the Seattle area. Command line access is wonderful.
  • HA/DR works well out of the box, and we also use block-level replication for DR, which is a huge benefit.
  • Stability. I hate to bring a curse on myself for saying this, but Db2 itself is extremely stable and we keep incredible up time.
  • Supports some of Oracle's SQL
  • Tight-knit community.
  • Support is fantastic.
  • IBM is really behind in delivering developer tools. They pride themselves on Data Studio, but it is just frustrating.
  • Marketing. Horrible to do a Google search and get returns for a COMPLETELY different product, for z/os. Why they share the same name is beyond me. Better marketing would also increase the user base and help the product mature.
  • Slower than the competition to roll out next-generation features.
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.
We don't use the scalable options, such a PureScale.
Score 10 out of 10
Vetted Review
Verified User
Review Source
Certainly from the whole organization: the product is used by all the ICT departments, by the departments that develop the applications and by the departments that manage the systems. Business departments use data to create dashboards or reports using Cognos automatically. The fact that it is multiplatform allows us to decide from time to time at what level the database must reside.
  • Easy to use with SQL programming
  • High availability
  • An extreme certainty of the data
  • High consumption of mainframe processor
  • Use of the plan for data access too rigid
  • Use of very limiting DRDA gateways
DB2 is suitable for any use. The main one is certainly the creation of an online database that can be queried online through TP queries and through batch reports. It is necessary to take care of the database maintenance to allow maximum performance, for this, there are the utilities that help the system operators to do it.
As an architecture, you can extend its use through features such as data sharing. Data sharing can essentially share data between DB2 members to allow queries from every system that is part of the enterprise. It is, in fact, a standard among relational DBs because the price/performance ratio is very positive for us.