GetApp offers objective, independent research and verified user reviews. We may earn a referral fee when you visit a vendor through our links.
Our commitment
Independent research methodology
Our researchers use a mix of verified reviews, independent research, and objective methodologies to bring you selection and ranking information you can trust. While we may earn a referral fee when you visit a provider through our links or speak to an advisor, this has no influence on our research or methodology.
How GetApp verifies reviews
GetApp carefully verified over 2 million reviews to bring you authentic software experiences from real users. Our human moderators verify that reviewers are real people and that reviews are authentic. They use leading tech to analyze text quality and to detect plagiarism and generative AI.
How GetApp ensures transparency
GetApp lists all providers across its website—not just those that pay us—so that users can make informed purchase decisions. GetApp is free for users. Software providers pay us for sponsored profiles to receive web traffic and sales opportunities. Sponsored profiles include a link-out icon that takes users to the provider’s website.
IBM Db2
Flexible data management platform
Last updated: October 2024
Functionality
4.4
/5
52
Total features
8
3 categories
IBM Db2 features
Common features of Data Warehouse software
Functionality
4.5
/5
461
Price starts from
No pricing info
Luis Alexis R.
Used daily for 2+ years
Review source
Share this review:
Implementing in record time allowing operating different system projects in the companies where I worked, you can be quiet because the data of the companies are based on a robust database eliminated the level of distress, allows access to your level of user user security to the system users allowing them to elaborate the data of the database in an excel sheet for example.
Easy database Implementation easy administration can be managed from any station the level of specialization is much lower than any other database, robust and recovery by indexes, interconnects with other databases such as Sql Server and allows data sharing in Immediately, its level of robustness and integrity is unique.
Proprietary database, requires a lot of Hardware for its good performance and its costs are high.
Maha S.
Computer Software, 501-1,000 employees
Used weekly for 2+ years
Review source
Share this review:
The main project that made me involved in working with DB2 is a transactional concurrency benchmark that compares IBM DB2 to Oracle 10g RDBMS. The benchmark results demonstrated high scalability and availability properties in DB2 but the TPS measures showed a better performance of Oracle 10g on HP ML350 servers. DB2 supported better concurrency in bulk data-intensive SQL queries but lagged in computation-intensive tasks.
The programming language support is definitely something that needs improvement in addition to cloud integration and deployment tools. Many other commercial RDBMSes (such as Oracle) are leading ahead on this front. OS support, such as testing OS X platforms, can be also better provided in DB2l
Verified reviewer
Insurance, 201-500 employees
Used other for 1-2 years
Review source
Share this review:
I would recommend use of DB2 in modern tech advancements. Light weight DB like MySQL, postgres are much better.
Db2 was used in our mainframe application. it accepts standard sql syntax. can handle large amount of data.
As data grows in production environment, it becomes slow. Thread hung and application performance degrades. Also it's costly.
Verified reviewer
Food & Beverages, 1,001-5,000 employees
Used daily for 2+ years
Review source
Share this review:
Over 10 years using DB2 I can affirm that it is a very secure bank, with updates that bring new features, high compaction power and geographic contingency features gave us the security to work with SAP.
DB2 HAS A SERIES OF TOOLS THAT ARE DIFFERENTIAL, BUT HIGHLIGHTING THE CAPACITY OF SELF-MANAGEMENT (PARAMETERIZATION) AND DATA COMPACTION. ARE STRONG POINTS TO CONSIDER.
The acquisition cost can be a hindrance in the acquisition negotiations. Support is also a weakness for the cost, forcing the use of DB2 communities for troubleshooting.
Sean Z.
Information Technology and Services, 11-50 employees
Used daily for 2+ years
Review source
Share this review:
Db2 scales very well AFTER a certain point. Support is excellent, it's easy to get stood up once you have a feel for what you're doing.
Scaling: for instance it won't run on small machines too well. This becomes important if you're running a local copy for development or testing. There is a free Community Edition to play with, but can't take advantage of tons of ram or CPU, but good for POC.
Riya J.
Computer & Network Security, 1,001-5,000 employees
Used daily for 2+ years
Review source
Share this review:
We are using IBM db2 to store large volume of sensitive user data which scale automatically when required, it allows multiple concurrent transactions with no data redundancy and maintains the isolation property.
IBM DB2 provides the low latency and high data availability, It provides automatic scaling and high security for the large volume of data. It is robust No matter how much amount of data is, IBM DB2 will never fail.
IBM Db2 is a bit expensive and not all the SQL standards available in the IBM Db2
Warwick B.
Information Technology and Services, 1,001-5,000 employees
Used weekly for 1-2 years
Review source
Share this review:
This tool is effectively and efficiently being used in some specific departments of our organization. Overall, it is a great tool that has been really beneficial for our company. I find the customer support of IBM Db2 the best product support team as whenever we have questions they just respond to them in the quickest way.
I have been using this product in our company for a long time as Database-as-a-Service on our cloud for different requirements such as storing and even manipulating data safely with timely availability. This product has been providing services that help in storing and running all the problems in order to evaluate the data. This tool allows us to modify the processing speed of our company’s data just to enhance the overall user experience. Moreover, I am a frequent user of this tool and having great experience of this tool.
I felt there is a storage capacity problem which sometimes makes it difficult to check the effectiveness of the entire database.
senthamizhselvan E.
Insurance, 5,001-10,000 employees
Used daily for 2+ years
Review source
Share this review:
This can hold n number of records and easy to access it via online application and updated using the informatica
The application looks and query are bit complicated compared to SQL
Verified reviewer
Information Technology and Services, 51-200 employees
Used weekly for 2+ years
Review source
Share this review:
Have used DB2 as a Relational Database (RDBMS) for the past 10 years, primarily to support SAP based enterprise workloads. IBM's development of DB2 has been fuelled by one of its largest customers - SAP. As such this review will be biased towards SAP. I started with DB2 7.5 on IBM's flagship AIX Operating System, and it has come a long way. These days AIX is dead (unfortunately), and IBM's Power platform is leveraging Linux. DB2 of course supports the big-endian based Power platforms, and the little-endian based x86 platforms that run both Linux and Windows. DB2 is very versatile as a database, and supports most features that enterprise-based databases like Oracle support. It really is a matter of choice. DB2 administrators are obviously not as easy to find as Oracle's, but so long as the DBA's have good knowledge they can be cross-trained easily.
- ACID compliant like any good RDBMS (Oracle, MSSQL, SAP HANA) - Runs well and scales well on IBM's Power-based platform, and commodity x86 hardware running Linux/Windows - Various editions to suit customer needs and requirements. For example the Developer Edition is fully featured and is completely free for developers to use, or all the way to Enterprise Edition for state-of-the-art functionality (In-Memory based Columnar Tables thru its BLU functionality, High-Availability, Disaster Recovery etc. to prevent Single-Points-of-Failure). Rivals the existing enterprise RDBMS's
- Even though there is a GUI for point-and-click administration (IBM Data Studio), to really flex the database's features and functionality command-line tools are required (like Oracle :-)
Steven C.
Financial Services, 10,001+ employees
Used daily for 2+ years
Review source
Share this review:
Straightforward to install and manage. Solid deployments but features can be behind. This is acceptable in our organisation, but may not be desirable in cutting edge companies.
In my employed role we use DB2 for warehousing, marts and as simple data stores. It is an integral part of back and metadata for Cognos and DataStage. It was simple to install and by default comes as self managed. We also deploy this for hosting customer data and integration with net backup, ha solutions and job scheduling is industry standard.
Vendor can be a little hard to work with on issues, getting the required information can be a drawn out process when trying to fix a live issue. This has improved over the years and support is more flexible in investigating while reports are generated. Functionality is competitive, but bleeding edge features (NoSql) can lag behind others.
shashank v.
Information Technology and Services, 501-1,000 employees
Used daily for 6-12 months
Review source
Share this review:
My experience using this RDBMS software is very good as retrieving of data from the database is very fast. We can execute complex queries in a smooth way. I actually wanted to store XML data inside the database in case of any B2B transactions that I need to store for further processing. DB2 database has the capability to store XML data and store some large files in regards to that transaction details.
1) DB2 is very cheap, easy to install. We don't have to worry about license costs as they wouldn't be more than that in Oracle. 2) It can run on any OS like windows, Linux, Mac. 3) We can use DB2 along with XML data also. 4) The retrieving of data from the db2 database is very fast which is actually a very good feature. 5) Can store large files in the database in an easy way. 6) We can store the data in different locations across the data and the data can be accessed from different locations in a faster way. 7) Index feature is available in DB2 to identify a unique table out of thousands of tables in DB2 database.
I didn't find any flaws using this software.
syed f.
Information Technology and Services, 1,001-5,000 employees
Used daily for 1-2 years
Review source
Share this review:
As of now ibm db2 database is the best provided by IBM technology which have best costumer support and best recovery system where need not to wait long time best resolving any issue are given as fast and can and easy to handle and use
there no least in IBMdb2 which has the best over all experience ever has has the best user experience till now
Jeremias E.
Education Management, 1,001-5,000 employees
Used weekly for 2+ years
Review source
Share this review:
Learning a fully functional database or DBMS may require an educational institution to buy licensed software to be installed in the laboratory. IBM DB2 Express-C is a free closed- source software that a student can use. Even a student could download and have the personal copy of the application as he learns database during the course.
IBM DB2 gives a start up point for a student to learn databases. All the features a DBMS have are provided by DB2. The product supports almost any front-end application that requires database. All the drivers are provided as you setup a connection to an application. IBM DB2 is not limited in learning SQL scripts. You may initiate also database back up and security, XML, stored procedures, and user-defined functions.
IBM DB2 is a high-secured database server. You may be lost in the installation process if you missed one of its steps. If you experience failed installation, uninstalling it may not fully do the trick. You need to delete folders or directories it has created during installation.
Verified reviewer
Used daily for 2+ years
Review source
Share this review:
This database engine is robust, with many tools and features. Easily upgraded. Minimal maintenance needed after it is up and running. Able to use either the command line interface or GUI to access and manipulate databases.
This database engine is robust, with many tools and features. Easily upgraded. Minimal maintenance needed after it is up and running. Able to use either the command line interface or GUI to access and manipulate databases.
Documentation needs to be more extensive, as you have to pay for customer support. Takes quite a bit of getting use to, as syntax varies greatly from other DBMSs.
Mehak A.
Computer Software, 1,001-5,000 employees
Used daily for 1-2 years
Review source
Share this review:
We used it for projects that have a huge database and complex queries, the experience was great as the ability to handle complex queries reduced the load on our application.
It's fairly easy to set up and offers a lot of functionality, it's very easy to connect to most of the UI tools and framework. The security features make it ideal for banking applications. It is such a powerful tool that optimized requested works super fast.
The only issue I think is its price, Db2 is quite costly as compared to its competitors, it does offer a great selection of feature so that also can be overlooked.
Verified reviewer
11-50 employees
Used daily for 2+ years
Review source
Share this review:
Installation is very easy and when installed it's ease of use, very convenient. It's also very easy to connect to other tools like DBVisualizer which gives another way of viewing the tables and info.
They need to improve the help online to find some commands, and the explanation on the commands as well.
Lukasz P.
Retail, 201-500 employees
Used daily for 2+ years
Review source
Share this review:
Stability , performance , reliability
This product is very stable , it can be fully trusted . It's optimisation is perfect - every request can be optimised smoothly and without user interactions
Price - it could be better - but You know that Your money were well spend . Also support could be more active
Alexandra V.
Automotive, 201-500 employees
Used daily for 2+ years
Review source
Share this review:
DB2 provides best relational database for huge amount of data.
Robust relational database management system to store huge amount of complex data with high scalability and performance SQL dialect.
High cost product and its version upgrades require an outage.
Verified reviewer
Information Technology and Services, 5,001-10,000 employees
Used daily for 6-12 months
Review source
Share this review:
We load all the sales data into DB2 system and will derive analytics on top of it. I can recommand if you have lot of budget to put on database managemnet.
1) DB2 has extensive functionality, has a lot of built-in features. robust database software 2) easy to use, and MPP systems which make the system to process data parallel. 3) DB2 SQL is anscii standard so migration to/from other databases would be easy.
1) expensive compared to other solutions available in market. 2) Few of the DB2 specific syntaxes are non convertable when we move to other databases.
Nazeer S.
Information Technology and Services, 10,001+ employees
Used daily for 1-2 years
Review source
Share this review:
DB2 is one of the most used DBs. It is based on Mainframe technology. It easily integrates with IBM BPM, IBM Datapower very well. Task Scheduler component of DB2 allows for statistics gathering and reorganization of indexes and tables without user interaction. DB2 has comprehensive suite of security features such as authentication, authorization, trusted context, auditing, encryption, and fine-grain controls.
No pros were added to this review
Pricing is little high
Verified reviewer
Information Technology and Services, 5,001-10,000 employees
Used daily for 1-2 years
Review source
Share this review:
Overall satisfied, used in couple of my projects, even with AS400.
Easy to integrate with any API with minimal configuration
Searching large amount of data might take time, indexing strategy could be better
Verified reviewer
Insurance, 501-1,000 employees
Used weekly for 2+ years
Review source
Share this review:
I liked the raw power of the utility. I was able to run millions, sometimes billions of rows of data through and it handled it just fine. The included functions were very helpful in translating complex data structures
None really. It did everything I needed. Maybe the only complaint would be how complex it is, but that is more of a feature not a bug
Gerson M.
Used other for 2+ years
Review source
Share this review:
DB2 is relatively simple to maintain and performs very well.
Super powerful and valuable for its automatic applications, security, data integrity oriented and the backup and recovery features. Reliable for any volume of data and transactions.
Not many updates or improves for a very long time. Forcing to move your data to the cloud. For some that's not an answer. However I recommend it.
John E.
Information Technology and Services, 10,001+ employees
Used weekly for 2+ years
Review source
Share this review:
Like other IBM products, Db2 is light and easy to install and maintain. It's incredibly robust and can handle very large volume of data with ease. I also like the support for the product from IBM.
IBM Db2 is very expensive to maintain compared to its competitors. Another issue for me is the lack of timely updates.
RAJESH G.
1,001-5,000 employees
Used weekly for 1-2 years
Review source
Share this review:
IBM DB2 is an excellent database platform. We are able to use it as a database platform for large corporates. It is designed to store, analyze and retrieve the data efficiently, hence one of the commonly used database platform.
There is nothing which we do not like about this database platform. everything looks so good about it.