Skip to main content
TrustRadius
Db2

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

Review of DB2

9 out of 10
March 26, 2024
Incentivized
We are dealing with financial data of our org. We have multiple web applications (Financial applications like Core Banking, Pension / …
Continue reading

Db2 Review

9 out of 10
February 13, 2024
Incentivized
Db2 has been a critical component of our organization's data management strategy, delivering several advantages to satisfy our business …
Continue reading

DB2 review.

9 out of 10
February 07, 2024
Incentivized
DB2 helps design, store, and handle large collections of data. DB2 provides both on-premises and cloud hosting solutions. DB2 can be …
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
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/pricin…

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services
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.
Free Trials available here: https://ibm.biz/BdSWMA

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.1.

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

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(209)

Attribute Ratings

Reviews

(1-25 of 75)
Companies can't remove reviews or game the system. Here's why
March 26, 2024

Review of DB2

Score 9 out of 10
Vetted Review
Verified User
Incentivized
We are dealing with financial data of our org. We have multiple web applications (Financial applications like Core Banking, Pension / Salary Disbursement, etc.). We need to ensure 24x7 availability of all our online services to the stake holders as well as general public. Being the back born of our online applications, IBM-DB2 plays an important role in keeping our services to our stringent service levels
  • Evaluation & Contracting
  • service and support
  • Product capabilities
  • Product documentation
Its relaibility , Scaleability, replication tool HADR Security Managment and many more features makes it a very sound product. We face very less performance issue respect to other database products. IBM provided good support
Aman Makwana | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
IBM's Db2 is the most low latency enterprises database which supports for faster realtime as well as supporting low latency transactions equipped with full availability. Our use case for in order to use Db2 is to store all our banking related datas ( user data, bank/ATM branches data, Transaction purpose ), Assets inventory and some data of our own datalake which helds massive amount of data for showcasing analysis for various use cases.
  • Support for Integrations with Public cloud vendors
  • Rich Monitoring and Metrics so that a team can focus less on DB administration tasks and can focus more on Customer Experiences and Product Wellness, Queries monitoring/Indentification of slow queries, Query recommendations.
  • Database Scalability, Availability is very high
  • Migration Assistant so we can easily migrate the database from any platform to IBM DB2
  • Documentation needs bit attention as we have to find many things which can be found very easy
  • Good UI for monitoring, user can create own custom DB dashboards
Products which are at very high scale in Storage,traffic patterns, Live analysis, realtime streaming, Transactional workload. IBM's Db2 is a jack of all these above mentioned trades. IBM's Db2 is not suitable the very small scale workload as it is bit expensive.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
IBM's Db2 on Cloud has been our primary DBMS software since our migration to the cloud. Our use of Db2 extends across various functions within the organization, including student and employee data management, ERP backend (for enterprise resource planning), transaction processing, and analysis. The scope encompasses the entire lifecycle of our educational and administrative processes, showcasing Db2's versatility and reliability in supporting a large and complex institution.
  • Can easily be scaled to growing data volumes.
  • Seamless integration with ERPs.
  • Optimizing queries.
  • High availability, minimum downtime.
  • Built in analytics functions would be useful.
  • Real-time monitoring and alerting can be improved.
  • Support/Documentation.
Db2 is well suited for large-scale relational data management, transaction-intensive environments, and complex workloads. It excels in scenarios where there is a need for integration with enterprise applications. It is less recommended in cases where deployments are small-scale with minimal data management, transaction loads are simple, or resources are constrained. In all these cases, a simpler DBMS solution is recommended.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
When we initially looked at Db2 the use case to drive adoption was geared towards control of large scale unstructured data which was sourced from many different sources integration methods. From that initial scope, you can image the workload and compute problems that you have in just extracting, loading, and running data quality processes on that data even before beginning to start to refine and curate for many different presentation layers. Db2 offers a wide range of integration support, has the agility to handle large scale enterprise workloads, and most import offers the flexibility of cloud compatibility.
  • Query optimization capabilities - algorithms drive analysis and optimization execution plans for basic to complicated complex queries
  • Security built with data design in mind - encryption, access controls, and auditing are fully baked in ready to use amongst many other security features
  • Disaster recovery and availability - replication, automatic failover, and failure secondary copy mode for critical workloads and increased uptime
  • Learning curve for DB resources - Improvements to UI or native command line built-ins can help with increasing efficiencies for DB resources
  • Better resource utilization monitoring and recommendations
  • Continue to adopt support for modern frameworks and languages making it easier for organizations to see making Db2 the easy first choice
I could think of a couple but the obvious is in Fintech and Retail, because of the amount of transactional and event level data for global operations. It is imperative to have a solution that can handle such large scale date, in real-time and batch delivery for inbound and outbound delivery, and ultimately ensuring that workload management is supported in some cases for around the clock SLAs.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use Db2 as the Application Databases that we have and the processes that utilize them at SSE/OVO Energy. A Db2 Sub-system can itself be part of a Db2 Data Sharing Group. Db2 Data Sharing allows us to spread the workload and resources of Db2 over more than one LPAR. The assigned Application databases are accessible through the Db2 sub-systems of the group. At SSE, we have several Data Sharing Groups. Each one has two sub-systems, these sub-systems running on separate LPARs. Each Data Sharing Group has its own unique name, there are several ways to connect to Db2 when wishing to access the databases. The Application that we use here is called the Customer System (also known as the CS Database). CS comprises 17 databases totaling over 1100 tables.
  • It reduced the amount of time we spend managing data
  • A high degree of availability
  • Data Protection and data integrity
  • Exceptional scalability with a high volume of transactions
  • Partition by growth tablespaces
  • Data refresh
  • Integration with cloud
Unloading all tables on the Invoice Database and Transfer, and then transferring the data off the mainframe is much faster. It was at some point a bit less appropriate for Windows support while we executed a series of jobs to read the Db2 Unload files. For each partition, the file is reformatted and processed by a Cobol program. A DFILE type file is produced. This file is then read by another Cobol program, this program produces an SQL update file. Execute File Transfers to Windows Server.
Rao Tahir | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
It can be used in both ways with or without relational concepts which helped with the current requirement of our business module where we need to be able to store data of both nature, structured and unstructured for us to help minimize the data loss which is incredibly sensitive and important for the business growth and fulfilling product needs.
  • XML structured data storage
  • Relational data storage
  • Materialized query table
  • Online backups need to be taken only in an offline environment which is quite troublesome because you don't always have the option to go offline.
  • Extensibility for buffer pool size in case of large data sets sometimes some tables could need more size for storing which is not possible at the moment.
  • Could be a lot more handy if they could introduce temporal tables like the ones in ms SQL.
it is well-suited for mid-sized multipurpose data storage which is very likely in some integrated platform that requires multiple formats of data fetching and storage for pushing or pulling into or from the external or internal system.
February 13, 2024

Db2 Review

Score 9 out of 10
Vetted Review
Verified User
Incentivized
Db2 has been a critical component of our organization's data management strategy, delivering several advantages to satisfy our business needs. It helps us to achieve our goals. One of the main advantages of Db2 is its dependability, which has continuously supplied us with secure and rapid access to our data.
  • Ideal for storing and organizing our client's data
  • Compatibility with many systems makes integration smooth
  • Processing of queries happens in milliseconds
  • The software upgrade process is quite hectic and lengthy
  • Rest is all good as per my experience while using it
Db2 database is highly optimized and works very well with IBM products. They assist me in setting up indexes on massive data sets. My previous business employed Db2 for its backend application. Its Integration allows users to connect to a wide range of application programming interfaces via drivers. It is no SQL database so data can't be stored in the form of tables.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
IBM Db2 is a highly scalable, secure, and reliable database management system. It has capabilities such as advanced query optimization and efficient resource management. The biggest problem that my company faces with third-party logistics is that every movement of every shipment is captured. And for that, we require a reliable and efficient database management system. This is where Db2 comes in. Various projects like landing profiles, weak links capturing in a logistics network, etc. are all dependent on Db2. All the Power BI dashboards are also linked with Db2 for real-time accurate KPIs visibility.
  • It's capable of handling large volumes of data, as in our case, every shipment's information.
  • It provides advanced query optimization, enabling quick response and real-time visibility via dashboards.
  • It has easy integration with other IBM products.
  • The biggest challenge is to identify the correct configuration as per the business use case. There should be some sort of AI help for the same.
  • Difficult to use for new users. There should be better training modules available.
  • Requires huge investments. They should have more plans for smaller organizations.
For organizations having huge data volumes, it is highly recommended to go for Db2 while in the case of smaller organizations, simpler solutions should work just fine. In my company, with capturing every shipment journey, the data volume generated exceeded the limit of simpler solutions, hence the optimal choice was to go for Db2 for various use cases involving ML/AI projects and visual KPIs visibility dashboards. Almost all our projects are dependent on Db2's quick response capability.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
After almost 4 years with Db2, I can confirm its reliability and accurateness and many features. As an illustration of its stability, it handles our situation with many transactions without issues and complaints. Also, due to its cross-platform interoperability, our efficiency increased, and we gained useful information. Finally, troubleshooting is very easy if any issue arises and can be solved very easily with detailed documentation and a helpful community.
  • Compatible with almost every 3rd party application, it is easier to link and integrate.
  • Very accurate and reliable. It has a reliable community and detailed documentation.
  • Has great data protection and security and robust backup options.
  • It is very difficult to setup or configure, even with the help of the documentation. So, make the setup process simpler.
  • The support takes quite some time to reply to our queries, which is sometimes frustrating.
  • There is nothing else that I see can be improved. Maybe a better UI or dashboard would be great.
Both end users and programmers benefit from its reliability, accuracy, and simplicity. It offers the best cloud database management choices, which are very reliable and have almost zero downtime. With it, you can easily handle surges and loads without affecting server or database availability.
February 13, 2024

Db2 is good for you....

Score 10 out of 10
Vetted Review
Verified User
Incentivized
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
Somnath Nayek | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
IBM Db2 is one of most highly reliable,scalable and high performance db tool I ever worked with.during my Tenure worked as a product admin my experience with this application is constantly demonstrated its reliability and comprehensive features set.it provide full set of data redundancy and 100% availabilitie like other famous db.
  • use in project where we have house database and complex querry to slove
  • easy installation and also integrate with cloud vendor application for better visibility.
  • robust,lost of flexibility
  • ideal for big org
  • this is complex to manage
  • cost of this application.
  • as data grow its became slow
I used ibm Db2 with some oracle RDBMS..The result of ibm Db2 was demonstrated high scalability and availability. it's show better performance with oracle db.i used other vendor db tool but it's performance make it perfect to work with heavy data
Score 6 out of 10
Vetted Review
Verified User
Incentivized
DB2 is used as RDBMS for transactional and reporting applications. We have built a custom application using DB2, and it is also used for reporting and analytics purposes.
  • Reporting and analytics.
  • Data storage.
  • Data retrieval.
  • 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.
  • Storing blobs.
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.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Our main student information system uses a Db2 backend. This allows us to store basic information on students, staff and parents.
We then use it to track academic marks, reports and pastoral comments.
We can then use a range of tools to produce reports and experts for different areas of our school.
  • It performs well with large data sets
  • It is scalable
  • Good security
  • Db2 connect with many education systems
  • Can be slow
  • Support can be tricky
Db2 is great as a relational database. If you are trying to manage connected data, say purchase transactions or connected info like our case of student information. We can show connected reports and marks to a student plus family information and charges to their account for things like printing costs or devices repairs.
Less suited applications include more modern setups. Where you are blending roles. Db2 requires specialised skills as query’s are different to SQL. So your base level database admin may require training or you’ll need a specialist contractor.
February 07, 2024

DB2 review.

Score 9 out of 10
Vetted Review
Verified User
Incentivized
DB2 helps design, store, and handle large collections of data. DB2 provides both on-premises and cloud hosting solutions. DB2 can be fine-tuned to scale according to the load, improving performance. DB2 can handle structured, unstructured, and relational data on one platform itself.
  • Availability
  • Flexible scaling.
  • Security
  • UI functionality.
  • The cost is high.
  • Complicated queries.
DB2 is well suited for applications involving large amounts of data, like machine learning. DB2 provides API support for many languages.DB2 has an excellent compression feature. Not all applications work with the DB2 database. There are many new databases available currently that are faster in executing queries and have better UI experience.
Prajwal Shetty | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Db2 is an object-relational database. It supports database servers; it also extends to support object–relational features and non-relational structures like JSON and XML. It provides high availability and helps with zero downtime and no data loss. It also aids in data partitioning by indexing and delivering optimal performance since it has data governance in Unity catalogs in Data Lakehouse.
  • Data Governance.
  • High availability disaster recovery.
  • Data replication.
  • Data partitioning can be optimized with better partition algorithms.
Db2 is well suited for the High data availability, which significantly helps the enterprise by providing zero downtime. This resulted in fewer outages and a great customer experience. Often, Db2 lags in data partitioning since the algorithm's performance is not that great compared to the other object-related databases.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Our organization use IBM Db2 to leverages its features such as Performance Optimization, backup and recovery, and resource management to ensure the reliability, scalability and performance of our backend used for demanding API-driven applications. It also plays a crucial role in making sure data integrity, security and compliance with regulatory requirements.
  • High Availability Disaster Recovery
  • Scalability
  • Real-time Data Processing
  • Open Source Initiatives
  • Automated performance tuning
  • Simple configuration
Db2 excels in mission-critical applications requiring high availability, scalability, and robust security. It may be less suitable for smaller projects with limited resources, as its initial setup can be complex. It's well-suited for industries like finance, healthcare, and telecommunications. Meanwhile, organizations which heavily invested in non-relational databases might find a transition challenging.
February 07, 2024

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.
Michael Attea | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We leverage Db2 as a reliable dependable powerful scalable relational database management system that handles massive data storage with all the data quality and governance enhancing value delivery delivered by relational databases architected for corporate cross functional integrations and actionability.
  • Best of both worlds agility oweing to on-premises and cloud based options
  • flexibility of scaling and handling of more data types than SQL
  • Powerful scalability and capabilities alongside user friendliness of relational databases
  • Can be more challenging than alternatives to remodify / alter programming of frameworks
  • controls minority of market share which can translate to less employees enthusiastic to leverage
It's particularly well suited where scailability security and agility is the objective and there is desire to leverage both cloud and on premises relational database warehousing. This can be particularly attractive for more data security sensitive industries with lots of data to store and keep protected.
February 06, 2024

Db2 Review

Score 9 out of 10
Vetted Review
Verified User
Incentivized
Db2 is the database of choice for all our mainframe applications in our organization. Many mission critical applications are using Db2 database to manage their work. It is a very high performance database. There are excellent tools available to manage the database such as Platinum etc. You can use it us dbeaver or other windows based software client.
  • backup and restore of database very easily
  • Good database security for access
  • Easy to Administer
  • Not available as option in Azure Cloud.
  • plan rebound that is required after the database changes
  • hard to find good Db2 DBA
Applications that need highly secured database.
Applications that need massive scalability and very high volume for very fast performance. Applications like
Very good for low latency transactions
It is very highly reliable, scalable and with very high performance.
Database of choice for credit card companies/insurance companies and any kind of financial transactions.
IT is one of the most matured relational database
Sharang Dwivedi | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Db2 database provides the reliable transaction processing (OTLP) capability along with robust data security and compliance features. High availability and disaster recovery is one of the critical aspect provided by the Db2. Db2 database has been used to store the customer information, policy details, offers, discount calculation, insurance claims etc. Across the organization IBM products were used so Db2 provided a seamless integration.
  • Integration with other IBM products
  • Online Data processing
  • Cost effective as compared with Oracle
  • Data warehouse
  • Lacks 3rd party integration or limited flexibility.
  • Getting Db2 experts now a days are difficult.
  • Other RDBMS are evolving much faster than Db2 features.
Db2 has been able to handle large transactions efficiently. Db2 offers robust security features, including access controls, encryption, auditing, high availability and disaster recovery etc. have been in the center place when we chosen Db2 database. As Db2 is IBM proprietary product hence not having very much open source integrations/tools to run the operations.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We have used the DB2 database for our property and casualty insurance project with one of the global insurers. We use the Guidewire insurance policy admin tool for our underwriting activity transformation and there we integrated Guidewire with db2 for data management of various global-level accounts. We did data mapping by first defining the database schema to align with Guidewire’s data model. Schema involves the creation of tables, indexes, and relationships by using Db2.
  • Db2 integrates well with a Guidewire or any other policy admin systems in the insurance domain.
  • Data synchronisation in db2 helps with data consistency.
  • Integration complexity was a challenge because the Guidewire model was different.
  • NoSQL databases are not much developed.
Db2 applications have a wide range based on their market projections or status; however, based on my experience in insurance, they can be used for managing policy data, claims information, and customer records or Master data management. We found that it lacks strength with forms management in our project. It does not provide services for forms or policy documents integration models.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Its a highly underrated DBMS system which has lot of capabilities.
We have been using this for large scale OLTP applications . It has good capability to handle huge number of concurrent users . We have few thousand's of users accessing this system. We have very minimal performance problems and very has good performance tuning solutions available . Implemented encryption as well.
  • Handle Large Loads
  • Good Backup and Recovery Options
  • Disaster Recovery Option
  • High availablity options
  • Security Feautres
  • Make it more user friendly
  • Complex commands
  • Third Party Integration to manage backups etc
It can be used where High Performance is desirable . This comes with lower licensing costs compared to its competitors . It gives the on-prem and cloud option , can be chosen per our requirement .
Its capable of storing large amounts of data , personally worked on 5TB database
Rohan Kumar | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Because Db2 is scalable, it can be used by both big and small businesses with different types of data requirements. To obtain data and test my applications using various data sets, I primarily utilize SQL scripts. The financial and demographic data that form the foundation of our system are ideal for the Db2 database. With all of our sensitive data, the system's security is ideal.
  • Reliability and Availability
  • It has Advanced Analytics
  • Security features are great
  • UI can be improved.
  • It has learning curve.
  • Less Integration options
IBM prioritizes availability and dependability in Db2, which makes it a strong option for applications that are mission-critical. Our business clients required a highly accessible database system that could grow with them easily. Although there were other possibilities, IBM Db2 offered smooth query execution and multi-cloud capabilities. This solution proved to be steadfast due to its potent performance and IBM Db2's dependability.
Score 6 out of 10
Vetted Review
Verified User
Incentivized
In financial sector the organisation deals with high volume of data transaction which should be highly reliable and secure at same time. IBM Db2 can help to meet these standards and helps client to effectively manage and process massive data while ensuring integrity and complaince with regulatory standards
  • Security
  • Regulatory complaints
  • High volume of data processing
  • Cost
  • Hardware optimisation
  • Administration
Well suited for use cases such as Regulated industries,Data warehousing,Mixed workloads
Less suited for scenarios such as small businesses, simple data storage, and community driven developement etc.


January 31, 2024

Hello

Khushank Sehgal | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Use case in organisation is managing data efficiently and security.
The business problem is the big data and this really helps in making it concise and presentable format which is really good in handling clients. The scope of use case actually very it is useful in case of some small case industries, large enterprise systems which eventually leads to using in a lot of varieties of industries.
  • Ensuring reliability
  • Security
  • Concise and presentable data
  • AI based features
  • Auto suggestions
  • Faster results
Db2 is well suited for security cases where tons of data needs to be reviewed. It is specifically helpful in the case of large industries where there is already a huge collection of data and it needs a large amount of time and attention to get a precise and detailed data.
Less appropriate would be small industries as there is less data and all we can do is build on based on existing knowledge.
Return to navigation