Db2

Db2

Customer Verified
Top Rated
Score 8.6 out of 10
Top Rated
Db2

Overview

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.
Read more

Recent Reviews

Db2 stability

9 out of 10
October 08, 2022
Db2 is a great database for large datasets. We use the DB2 database to manage our membership and other data. It is reliable and has a fast …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Db2, and make your voice heard!

Return to navigation

Pricing

View all pricing

Db2 on Cloud Lite

$0

Cloud

Db2 on Cloud Standard

$99

Cloud
per month

Db2 Warehouse on Cloud Flex One

$898

Cloud
per month

Entry-level set up fee?

  • Setup fee optional
For the latest information on pricing, visithttps://www.ibm.com/products/db2/pricing

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services
Return to navigation

Product Demos

IBM DB2 on Cloud - an introductory tutorial
02:41
Return to navigation

Product Details

What is Db2?

IBM Db2 empowers developers, DBAs, and enterprise architects to run low-latency transactions and real-time analytics equipped for the most demanding workloads.

From microservices to AI workloads, Db2 is a hybrid database providing availability, built-in refined security, scalability, and intelligent automation for systems.


Availability

Mission critical environments require continuous availability and tolerance for failure. Db2 availability enables users to run workloads without interruption.

Built-in security

Db2 protects data with in-motion and at-rest encryption, auditing, data masking, row and column access controls, and role-based access.

Scalability

Db2 grows with users, scaling up and out as workloads evolve and performance needs change.

Automation

Built-in container operators automate time-consuming database tasks, while keeping the business running. Users can build apps while using Db2's advanced workload management automation and ML-optimized query engine.


Db2 can be run in the cloud, on-premises, or in hybrid environments.

Db2 Features

  • Supported: Data compression
  • Supported: Query Compressed Data
  • Supported: Elastic scaling
  • Supported: Continual data ingestion
  • Supported: In-memory analytics
  • Supported: In-database ML
  • Supported: Multi model
  • Supported: Data Lake integration
  • Supported: High Availability Disaster Recovery (HADR)
  • Supported: Continuous availability
  • Supported: In-motion and at-rest encryption
  • Supported: Data auditing
  • Supported: Data masking
  • Supported: Row/column access controls
  • Supported: Role based access
  • Supported: Label-based access

Db2 Videos

IBM DB2 Tutorial

Watch IBM Db2 – The AI database

Db2 Integrations

Db2 Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsWindows, Linux, UNIX
Mobile ApplicationNo

Frequently Asked Questions

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.

Oracle Database, Microsoft SQL Server, and Google Cloud SQL are common alternatives for Db2.

Reviewers rate Performance highest, with a score of 9.9.

The most common users of Db2 are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews

(1-25 of 51)
Companies can't remove reviews or game the system. Here's why
Score 10 out of 10
Vetted Review
Verified User
An essential part used in the company is the IBM Db2 software to provide the database management cloud solution on our mainframe infrastructure. Super reliable and integrates exceptionally with the Cobol language, offering excellent performance in queries that require a large workload on the DBMS. We've tested several and it was the only one that could handle our data stream and responses in milliseconds. IBM still provides support for the tool, which also has a large community, mainly banks, which help and contribute to solving doubts and programming.
  • Extremely reliable DBMS with quality support.
  • It works with great encryption and decryption features.
  • Easy scalability.
  • Great connection between Cobol and db2
  • Queries and transactions in milliseconds.
  • Some query syntaxes are different, but in a short time it's easy to learn.
  • Licensing can be an issue due to the high value of the premium version.
The company has been using it for many years and I have been using it for just over 2 years. I feel the ease in obtaining the data. The solution can fit scenarios where there is quite a high workload and a low response time. Queries and transactions occur in milliseconds. Other backup/restore, replication and other features are fundamental and work exceptionally well. IBM is one of the most reliable companies and has been in the market for years in this segment and has helped us with support whenever we need it.
The solution easily supports scalability and can be increased with the acquisition of new licenses and features. Over the months we gradually increased.
Score 8 out of 10
Vetted Review
Verified User
Inventory, ingest and question open information designs utilizing a solitary stage that upholds tight joining with your information lake over cloud object capacity. While implementing of the data over cloud for analytics the queries, the implementation of data analytics over cloud is much simpler and efficient here. Provides a stage that limited grating for clients by being exceptionally viable with existing SQL code, and simple to incorporate with SAP applications.
  • Bind together your information.
  • Interface dashboards and reports with the force of quick ingest and querying for constant bits of information.
  • Enable high performance and cost predictability based on object storage
  • Simple, Efficient and Reliable
  • Auto querying techniques
  • More enhanced dashboard features
  • Simplified navigation while jumping in data
Its best suited where users want to create and predict with high-performance machine learning models inside data warehouse. The best feature is it can be integrated with the IBM AI: Watson for features and functionality. In helps the users perform real-time analytics and generate an instant report. However, prefetching and modelling of the data needs to be done at users end or in the different Db2 which can then be integrated again back here.
It was used on large sets of organized as well as unorganized data where it required removal of unnecessary information and then again regeneration of data. This was implemented easily using the classification techniques and the dashboard reflected improvised results after analysis of complete overall model.
Jeremias Esperanza | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
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
  • Connecting to report writer
  • 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.
Score 10 out of 10
Vetted Review
Verified User
DB2 HADR feature is widely used in our applications as continuous availability is utmost important for the business.
As finance institution we have high workload of transactions which cannot have downtime and HADR feature meets our goal.
  • High availability of mission critical business application using HADR.
  • During upgrade of OS or Db2, pretty much seamless upgrade is done.
  • Overall performance is great despite of our secondary node is remotely located.
  • Documentation is sometime unclear or confusing.
  • Would be good idea if we can estimate the time needed for index rebuild to complete.
  • Db2 primary should propagate all configs (DBM, DB, Registry) to standby automatically.
We needed to take backup of DB which is on remote location which is standby but currently HADR doesnt support backup of standby so Db2 was not well suited there and we ended up using storage level backup.
Pretty much our organization's critical applications are based on HADR functionality and so far other than smaller events we didn't have anything severe yet. Its widely used. We also like the simplicity of monitoring in HADR which helps us to understand the status in efficient way.
Score 8 out of 10
Vetted Review
Verified User
We use DB2 as a generic database for a wide range of front end employee facing applications - HTML and non HTML based (proprietary user interface). We extensively use DB2 for our Lotus Notes application. This application is used for task tracking, logging, project management, change control requests, incident tracking and response tracking on those said incidents.
  • Low latency
  • Simple design
  • Easy to use
  • Scalable
  • Seamless integration
  • Advanced functionality
  • Security
  • Incorporate more Analytical functions
DB2 is well suited for most of IBM applications and is easily configurable. It's easy to setup and link applications to. Troubleshooting is easy as there are tools provided out of the box to diagnose and research day to day issues. DB2 has a simple design and somewhat lacks advanced functionality when compared to other mainstream databases.
DB2 can be configured and can work with a variety of applications as opposed to how it was designed initially to only with with IBM mainframes. It's easy implementation process makes it a good buy for many organizations to scale their applications to be the best in terms of versatility, resilience and application performance
Score 10 out of 10
Vetted Review
Verified User
<div>I support the product IzPCA ("IBM z Performance and Capacity Analytics"). <br></div><div>DB2 have a <b><u>symbiotic</u></b> relation with IZPCA! Without DB2, IzPCA is nothing. <br></div><div><br></div><div>IzPCA continuously insert/alter/update data in <u>600+ DB2 table</u>s, inside each one of the IzPCA DB2 databases.</div><div>That data contains <b><u>important technical information</u></b> about a lot of products/processes in the mainframe environment (eg, CPU, storage, DASD, channels, MVS, TSO, DB2, CICS, IMS, DCOLLECT, WLM, Applications, Job accounting, System Performance, System Capacity Planning (Forecast and Simulation), z/VM, zLinux, z/TPF, and many others). <br></div><div><br></div><div>People from the many teams supporting these products/processes, use that data to execute <b><u>fundamental, and complex analysis/studies</u></b> about how the products are performing, about how the systems, as a whole, are performing too, as well as <b><u>forecast studies</u></b>, and <b><u>simulation studies ("what if" analysis)</u></b>. <br></div><div><br></div><div>These studies/processes, are <b><u>fundamental and critical</u></b> for the installation. <br></div><div>The support teams needs to execute them continuously, in order to have mainframes environments always in a <b><u>good shape</u></b>. <br></div><div>By consequence, DB2 is too, <b><u>fundamental and critical</u></b>, to allow the execution of all these important processes/analysis. </div>
  • INSERTs/ALTERs/DELETEs of rows in a table.
  • SQL queries
  • Many checks, before insering a row in a table (row duplication, data characteristics, data range, nuls, etc, etc, etc...
  • Maybe the SQL Reference manual have a chapter or an appendix, clarifying for each one ot the comands/functions/processes/etc at which level they act, row, table, tablespace, indexspace, stogroup, database, DB2 sub-system, etc
  • But if not, here goes the suggestion: Add it!
  • I do not know if the SQL Reference, or any other manual have this kind of information.
  • If not, I suspect it will be a good idea to have it.
  • The correlation between the various types of DB2/SQL data and the types in all languages available at the mainframe
  • I suspect a chapter, in SQL Ref manual, explaining in detail the operands working over two or more tables, will be of great help.
  • I remember the JOIN operand, but have a vague recall there are others.
  • You see, there is not even an small section about JOIN, with a corresponding entry in the CONTENTS list at the beginning of the manual. :(
  • Making a search for the word, we only see texts on how to use JOIN in such and such situations/conditions, but NO explanation at all about it
  • I made, too, a global search in most of the DB2 manuals. There are lots of rows with the word JOIN, but apparently again only to inform how to use JOIN in some situation.
  • Maybe in a good class of SQL they will explain the JOIN,
  • Unfortunately when I started to support IzPCA, I neede to learn DB2/SQL by myself, reading the manuals, and testing :(
  • A chapter or a major section explaining in detail the JOIN (and similar operands, if they exist), certainly will be of great help.
  • For me, and for the people starting now with DB2/SQL :):)
  • If that chapter or section, by any chace really exists, please, inform me the manual name. Thx :)
As I mentioned in previous questions I learned by myself all DB2/SQL subjects needed to execute my support for the IzPCA.

So, the only thing I can say here is, "DB2 is totally suited for IzPCA"
As a matter of fact, without DB2, IzPCA is useless. :)
By using DB2 only to support my IzPCA activities, my knowledge here is somewhat limited.
Anyway, from what I was able to understand, DB2 is extremely scallable.
Maybe the information below could serve as an example of scalability.

Customer have an huge mainframe environment, 13x z15 CECs, around 80 LPARs, and maybe more than 50 Sysplexes (I am not totally sure about this last figure...)
Today we have 7 IzPCA databases, each one in a distinct Syplex.

Plans are underway to have, at the end, an small LPAR, with only one DB2 sub-system, and with only one database, then transmit the data from a lot of other LPARs, and then process all the data in this only one database.

The IzPCA collect process (read the data received, manipulate it, and insert rows in the tables) today is a huge process, demanding many elapsed hours, and lots of CPU.
Almost 100% of the tables are PBR type, insert jobs run in parallel, but in 4 of the 7 database, it is a really a huge and long process.

Combining the INSERTs loads from the 7 databases in only one will be impossible.......,,,,
But, IzPCA recently introduced a new feature, called "Continuous Collector".

By using that feature, small amounts of data will be transmited to the central LPAR at every 5 minutes (or even less), processed immediately,in a short period of time, and with small use of CPU, instead of one or two transmissions by day, of very large amounts of data and the corresponding collect jobs occurring only once or twice a day, with long elapsed times, and huge comsumption of CPU

I suspect the total CPU seconds consumed will be more or less the same in both cases, but in the new method it will occur in small bursts many times a day!!
Bhanu Taneja | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
We are using Db2 for very critical applications where we need high availability and robustness. We are a retail and online business, biggest in Australia so the application demands a backend database which is able to handle such load and data. Using Db2 we are able to provide customers better satisfaction while shopping.
  • Handle huge data
  • Robust with big data
  • Huge range of application compatibilities
  • Easier than others to administer issues and performance bottlenecks.
  • Ability to restore tables from backups
  • Availability of Db2 on public clouds other than IBM
If the application is based on data warehousing then Db2 would be the best choice to opt for as over more than a decade of my working with Db2 I have found it extremely robust in DW's. It has also performed exceptionally well in case of OLTP databases.
The best thing about Db2 is its scalability. It can be used for small applications in parallel to the bigger applications as each DB is independent of each other. If the requirement increases in future it can be easily scaled as per requirements.
Score 10 out of 10
Vetted Review
Verified User
As a Db2 admin, among the projects I’ve handled that involved Db2 are:
  • Setup of HADR Table Partitioning Upgrade of Db2 from 10.5 to 11.5 and Fix
  • Pack Applications Database Replication using IBM WebSphere MQ
  • Installation and setup of Db2 databases and client servers
Most of the issues I’ve encountered were related to:
  • Restoration of local backup from one server to another
  • Long duration of local backups HADR Replication
  • Query Optimization
  • HADR Replication
  • Easy installation
  • Message Queue Replication
  • Duration of Backups
  • Table Runstats & Reorg Duration
The product is very stable and can be used with large databases and complex queries. In addition, opening of ticket / request for support is easy.
We use Db2 in one of our biggest databases and it can handle huge amount of complex data and queries quite well.
Score 10 out of 10
Vetted Review
Verified User
<ul><li>From the perspective of the engineer who designs the common infrastructure for our usage of Db2:</li></ul><ul><li>We use Db2 mostly for OLTP applications, some of them business critical with multi-million transactions per day</li><li>We also see increasing analytical workloads on these OLTP databases</li></ul>Underpinning infrastructure is IaaS VMs built on RHEL and deployed on:<br><ul><li>on-prem cloud platform (based on VMWare stacks)</li><li>public clouds like Azure, AWS, GCP</li></ul>
  • Rock stable database engine
  • Extremely consistent to deploy and operate across many major versions
  • Nevertheless increasing number of good features (e.g. time travelling, compression, encryption, Graph engine, etc.)
  • High level of compatibility with Db2 on zOS - easy to migrate
  • Hard to tell where Db2 really NEEDS improvement - I might have been working with that DBMS for too long...
  • Yes, there has been some reduction with Db2 support, but that's improved a lot again over the last year. And yes, there have been some flaws with new features and a few security vulnerabilities in the last 2 years, but that's also been stabilized quickly by Db2 development.
  • One thing that comes to my mind as an improvement would be a really great and flexible function for pivoting data. There are ways to achieve it, but flexibility and simplicity would be awesome.
I haven't really come across a scenario for RDBMS where Db2 is not very well suited. But then, I design and implement large scale, highly standardized, enterprise-ready estates with the goal of cost-effectively operating thousands of databases. I.e. my scope is rather on the infrastructure side than on functional details of Db2.
Many different scalability options from the very simple and easy-to-manage single instance with 1 to many databases to pureScale clusters.
Plus of course the imho unique DPF setup which pushes Db2's MPP capabilities to stretch a single database across many (physical or virtual) servers and even extends such huge systems to support HA configurations.
December 13, 2022

Why use IBM DB2?

Diovani Dupont | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
I'm a fan of IBM technology, I'm currently studying systems analysis and development, as I'm studying data science I needed to look for a relational database based on SQL where I could store my data. At the moment I use DB2 for studies so I opted for the DB2 Community license, it is simple and free.
  • Storage optimization
  • Rapid database development
  • pureScale technology, which focuses the database on availability and scalability
  • Simplicity and security when performing migrations
  • Ease and flexibility in implementation
  • The relational model requires a rigid schema that does not necessarily fit with some types of modern development.
  • Proprietary database, requires a lot of Hardware for its good performance and its costs are high.
  • As data grows in production environment, it becomes slow.
Db2 offers many advanced features to improve data and database management.Actionable compression can save storage space without sacrificing performance. Many query predicates can be evaluated without having to unpack the data.Performance of Hybrid Transaction Analytics Processing, or HTAP, is accelerated by Db2 BLU column storage with single instruction, multiple data, or SIMD, data skipping and skipping technology on LUW platforms, and the IBM Db2 Analytics Accelerator on z/OS.A DBA can build a temporal database using Db2 to allow system and business changes to be captured, maintained and queried. This allows organizations to store information related to past, present and future time, as well as use time travel queries to visualize past and future data states.AI and machine learning (ML) capabilities, including the augmented data explorer, offer natural language query capabilities, an ML query optimizer, and a hybrid data management platform to enable seamless sharing of structured data, not structured and semi-structured.The choice of deployment model includes on-premises hosted cloud deployment or managed cloud deployment.Db2 on LUW platforms offers an Oracle SQL compatibility option.Db2 for z/OS enables organizations to run mixed workloads with exceptional scalability, high performance and 24x7 availability.
Db2 for z/OS allows organizations to run mixed workloads with exceptional scalability, high performance horizontal growth, greater scalability is achieved, the system can grow beyond the limit of a single machine while your database remains intact. It improves performance, reduces resource consumption, maintains database integrity, and increases business resiliency.
Marcus Davage | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
We develop administration, performance and monitoring software for Db2 customers around the world, enabling them to become autonomous digital enterprises.
  • performance
  • scalability
  • reliability
  • security
  • portability of SQL with other Db2's
If you are processing hundreds of thousands of transactions per second, and want each and every one to be consistent, then Db2 is your bag.
If you want to increase the scale of Db2's processing power, just add another member to the data sharing group. Bang! Tens of thousands more concurrent users!
December 13, 2022

Db2 is good for you....

Score 10 out of 10
Vetted Review
Verified User
Db2 is used in factories, to collect all data about products produced.
It is used to insert/follow up orders of products
We also have a datawarehouse where we create all kind of statistics/reports
  • manageability
  • monitoring
  • easiness of use/administration
  • TSA and integration of other products
well suited : as Db2 is easy to use and administer, almost all scenarios where data is to be handled and/or be kept are suitable
the integration of XML is well done
we have small and larger databases. for the end-user we do not see any difference according the size.
it can handle both at the same speed
sometimes it is difficult to make the suppport people to understand our problem
if you submit a case, they only read the last sentences and request info/data that already have submitted
Score 10 out of 10
Vetted Review
Verified User
Powerful database platform in the central system of the organization, allowing the storage of data from many suppliers and other departments. IBM DB2 is an ingenuity tool that's easy to install, run and learn, plus technical support is there for you right out of the box. It is multi-functional with many platforms and fits with any necessary tools; on the other hand, this software is necessary flexible with document backup and recovery.
  • Automated system.
  • Ease of querying data.
  • Easy integration with other tools.
  • Intuitive features to improve integration.
  • If it could work faster from the cloud, it would be much better.
  • Otherwise, this platform can be used by experts and developers who are just starting out in this world.
Excellent product, very manageable across multiple platforms, paramount in recovery and backups. It has an automated system with great features that allow data to be stored easily. We have this software that is the best base for the data for a load of a quantity of data. With this relational database tool, we obtain excellent service in the company with excellent achievements. It has a quality technical service that makes what seems complicated easy.
This is not the best aspect of this database suction; I do not think it is scalable; it has many limitations thanks to the fact that it is actually a module that must be part of other IBM services to work in the best way, for this simple reason I consider that its seat is reduced, in the same way, it is a database system that we cannot stop using thanks to the excellent results obtained to date.
Score 10 out of 10
Vetted Review
Verified User
Proprietary relational database product for the storage and retrieval of all enterprise-powered data; It is compatible with other highly useful work tools for professional and business growth. IBM DB2 has an automated system that makes everything possible in less time than normal and in a perfect way since it is a very solid and robust platform that helps in the recovery of business data. It has the best technical team of any other product, always willing to collaborate.
  • Easy to install and run, no subject matter expertise required.
  • Great compatibility with other tools.
  • Your database is quite manageable.
  • Technical Service that guarantees the proper functioning of the product.
  • Search speed needs to be improved, it's quite slow.
  • Overall, this product has nifty features that work seamlessly with top-of-the-line technology.
It has a fairly stable database server that is compatible with other tools, making this software the best on the market in terms of data systematization and control; it is fully manageable with multiple platforms making everything easier. With this nice feature tool, everything in the organization works better than before; but on the other hand there is the search problem, because the platform becomes slow at times.
This IBM service is perfect for companies that have other services that can be integrated as in other IBM software; in relation to its scalability, I cannot give a precise opinion; based on the fact that it is an IBM database service, I consider that its The level of scalability is acceptable, but I don't think it will have an amazing level of enhanced growth, the company took advantage of this service to store important data, and it is used as an integrated module of another IBM product.
October 08, 2022

Db2 stability

Score 9 out of 10
Vetted Review
Verified User
Db2 is a great database for large datasets. We use the DB2 database to manage our membership and other data. It is reliable and has a fast query response over a large amount of data. We use either native IBM systems to consume the data or connect to it from PC-based applications like PowerBI or node js programs.
  • Return queries of large datasets.
  • Store data
  • Need options for reading in Foxpro data.
Db2 is great for any scenario where data is collected. One drawback is that the IBM machines it runs on are not very portable. When we needed to take our data to have on-site at a conference, we ported the data to an MS-SQL database running on a laptop.
Our use doesn't vary much. We have found it more than sufficient.
September 14, 2022

DB2 is Good

richard shen | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
It is used widely company wise by different department and different applications, mostly it is lagacy system, created in house or vendors. DB2 have very important company data, transnational and reporting.
  • DB2 has build in replication tools make online data replication/movement much easier and fast.
  • DB2 HADR is reliable, keep Database up and running 99.99% of time, switch beween servers in seconds.
  • DB2 Federation make the access to all kinds of Databases like in one.
  • DB2 is stable on Linux/AIX even Windows.
  • DB2 Locks is too strict, very little flexibility
  • Like to more built-in function, procedure for Analysis/Reporting
  • Love to see DB2 can go open source, so that it can get more developer involved
It is good to in traditional transaction DB world. Not easy to scale out horizontally, but vertically.
We have deployed DB2 in different environment, mostly of the system has 20 years of history.
As of scalability, we can do vertically so far.
September 13, 2022

Heavy but lightning fast

Score 9 out of 10
Vetted Review
Verified User
We use Db2 and LUW in our environment for almost everything; about a 90/10 split with some form of Db2 vs SQL Server. We use it exclusively for its horsepower, especially on z, leaving the smaller workloads to MsSS. We run our large, demanding OLTP applications on Db2 and it never seems to break a sweat.
  • transactional workloads at high volume
  • encryption at rest and in flight
  • manages large objects LOB/BLOB/XML well
  • everything about Db2 is 'heavy', even the Community edition and some of the clients
  • difficult to configure for beginners /option overload
  • LUW and z platforms have minor inconsistencies that really should be a non-issue
  • support seems to be declining in terms of quality/quickness of responses
Suited exceptionally well for Enterprise, not as much for the individual just needing a database. Not exactly beginner friendly but, I believe that is just tied to how complex a database really is, so I don't see it as a positive or negative. There are free tools for use with Db2, including IBM Data Studio. It's adequate, but not as intuitively put together as MsSS, nor most other 'consumer friendly' databases out there.
I give a 10 because it really can handle gigantic workloads, but for my other points up to this one it's because you're starting on level 50 instead of level 1 - heaviness of install, options galore, etc. It scales up well, but down only to a certain point.
Score 9 out of 10
Vetted Review
Verified User
I mostly work on javascript applications working WebSphere, and the integration of DB2 with both the software is quite easy and effective. We have never faced trouble with this. It is also supported for mainframe programs which give the added benefit that we can do batch processing on the mainframe.
  • Easy and user friendly. Secure and productive.
  • Easy connection strings via programmatic use and procs.
  • Database security, own interface, SPUFI, QMF.
  • On a black screen with no GUI, can explicitly go like DB2 visualizer.
  • More time required to pull data and time delay.
  • Not enough exposure to the product as a lead, need guidance from DBAs at times to learn.
  • Costing is too high.
We were using DB2 to help reorganize our company's data to make it easier to retrieve and recover at a moment's notice in case of equipment change and/or data glitch. It helps me manage databases accurately. It benefits both end users and programmers since it helps you to work easier.
Ken Shaffer | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
DB2 Data Warehouse and OLTP systems. LUW and Z/OS.
  • Bulletproof transaction processing
  • Continuous availability
  • Ease of Administration
  • Excellent throughput
  • Version upgrades require an outage.
Db2 is VERY well suited for high volume, large scale production OLTP environments. Also, with the DPF feature, it can handle the largest warehouse databases as well.
Lisandro Fernigrini | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
The project I am currently involved in implies retrieving data from multiple source systems from many companies in order to integrate them into a Corporate Data Warehouse. Some of the companies use systems that have their data stored on DB2, so we need to generate ETL processes against DB2 to obtain the data.
  • Reliable and secure.
  • Excellent performance.
  • Cross platform.
  • Lack of modern client tool to connect and query database.
DB2 has decades of history as a reliable and robust relational database. It may lack some of the latest features available on Oracle or SQL Server, but it is still a great tool to store huge amounts of relational data and be able to access it in a simple and efficient way.
Score 9 out of 10
Vetted Review
Verified User
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 put the health care insurance policy details in IBM DB2. High Scalability. Low latency. IBM DB2 provides a more powerful SQL dialect than Microsoft MySQL or Oracle. It has Self query tuning process.
  • Robust Relational database.
  • High Scalability.
  • High Performance.
  • Best Query optimizer.
  • Its costing is too high.
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
  • 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
  • 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.
Score 10 out of 10
Vetted Review
Verified User
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.
Valarie Thomas | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
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.
Return to navigation