Overview
What is Db2?
Recent 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 & consVideo 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!
Pricing
View all pricingDb2 on Cloud Lite
$0
Db2 on Cloud Standard
$99
Db2 Warehouse on Cloud Flex One
$898
Entry-level set up fee?
- Setup fee optional
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Product Demos
Product Details
- About
- Integrations
- Competitors
- Tech Details
- FAQs
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
Db2 Integrations
Db2 Competitors
Db2 Technical Details
Deployment Types | On-premise, Software as a Service (SaaS), Cloud, or Web-Based |
---|---|
Operating Systems | Windows, Linux, UNIX |
Mobile Application | No |
Frequently Asked Questions
Comparisons
View all alternativesCompare with
MySQL
MongoDB
Oracle Database
PostgreSQL
SAP HANA Cloud
Microsoft SQL Server
Snowflake
Microsoft Access

FileMaker Pro
SAP Adaptive Server Enterprise (ASE), legacy
SingleStore
Teradata Vantage Advanced SQL Engine (Teradata Database)
Sequel Pro
Reviews and Ratings
Attribute Ratings
Reviews
(1-25 of 51)- Popular Filters
Reliable database platform with impeccable support.
- 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.
Operating Data with IBM Db2
- 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
Db2 on Cloud: Your next cloud database deployment
- 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
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.
Scalable, reliable and compatible with a diverse set of applications
- Low latency
- Simple design
- Easy to use
- Scalable
- Seamless integration
- Advanced functionality
- Security
- Incorporate more Analytical functions
DB2/SQL being used together with another IBM product, IzPCA
- 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 :)
Db2 a powerhouse for Data warehouses
- 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
For the record, Db2 is Numbuh 1!
- 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
- 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
- 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.
Why use IBM DB2?
- 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.
IBM's Db2 database rocks. Does yours?
- performance
- scalability
- reliability
- security
- portability of SQL with other Db2's
Db2 is good for you....
- manageability
- monitoring
- easiness of use/administration
- TSA and integration of other products
ROBUST DATABASE, WITH A SOLID ADMINISTRATION SYSTEM.
- 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.
Reliable and robust software for the best business performance.
- 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.
Db2 stability
- Return queries of large datasets.
- Store data
- Need options for reading in Foxpro data.
DB2 is Good
- 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
Heavy but lightning fast
- 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
Best tool for working with database.
- 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.
- Bulletproof transaction processing
- Continuous availability
- Ease of Administration
- Excellent throughput
- Version upgrades require an outage.
A reliable RDBMS that does it job
- Reliable and secure.
- Excellent performance.
- Cross platform.
- Lack of modern client tool to connect and query database.
IBM DB2 The Most Powerful Relational Database
- Robust Relational database.
- High Scalability.
- High Performance.
- Best Query optimizer.
- Its costing is too high.
Highly reliable database service
- 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
Reliable cloud database
- Helps with latency issue.
- Availability of large number of servers.
- Improve the debug logs.
- Improve documentation.
IBM Db2 on Cloud, one of the best solution for cloud database.
- 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.[.]
- 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.