Who Uses This Software?
IBM Db2 provides solutions for Data Lake, Operational Database, Data Warehouse, and Fast Data.
Average Ratings32 reviews
- Overall 4.4 / 5
- Ease of Use 4.1 / 5
- Customer Service 4 / 5
- Features 4.4 / 5
- Value for Money 4.1 / 5
- Starting Price US$1.00/one-time
- Free Version Yes
- Free Trial No
Cloud, SaaS, Web
Installed - Windows
24/7 (Live Rep)
- Founded 1911
About IBM Db2
DB2 Enterprise for Linux, UNIX, and Windows is the ideal data server for the most demanding workloads. New XML support is designed to help firms minimize the time and effort it takes to persist and use their XML data reducing development costs and improving business agility.
IBM Db2 Features
- Access Controls/Permissions
- Backup and Recovery
- Data Migration
- Data Replication
- Database Conversion
- Mobile Access
- Multiple Programming Languages Supported
- Performance Analysis
- Data Migration
- Database Conversion
- Performance Analysis
- Storage Optimisation
IBM Db2 Most Helpful Reviews
Reviewed on 16/04/2019
Proven for enterprise workloads
Comments: 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
Cons: - 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 :-)
Reviewed on 01/10/2019
DB2 - The stable and reliable database
Comments: I work with DB2 for over 6 years. I participated in projects of implementation and construction of environments AIX and SuSe Linux with DB2 ensuring the geographic contingency.
The product is extremely reliable! Literally no problem.
It has extensions of high availability and geographic contingency that in my view are highlights. Easy to implement and it works!
Cons: This is not something I miss, but I believe it is a differential for some people. DB2 does not work very well with graphical tools. PLC is still the best way.
Reviewed on 27/06/2018
In My professional life I have used DB2 on the AS / 400 and e_Series platform for more than 15 years
Luis alexis R.
Comments: 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.
Pros: 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.
Cons: Proprietary database, requires a lot of Hardware for its good performance and its costs are high.
Reviewed on 28/03/2019
Best RDBMS Software
Comments: 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.
Cons: I didn't find any flaws using this software.
Reviewed on 29/05/2019
My DB2 Experience
Comments: 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.
Pros: 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.
Cons: 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.