IBM Db2 Database vs IBM Informix comparison

IBM Db2 Database and IBM Informix are both solutions in the Relational Databases Tools category. IBM Db2 Database is ranked #6 with an average rating of 8.3, while IBM Informix is ranked #24 with an average rating of 6.5. IBM Db2 Database holds a 7.2% mindshare in SQL, compared to IBM Informix’s 1.8% mindshare. Additionally, 90% of IBM Db2 Database users are willing to recommend the solution, compared to 85% of IBM Informix users who would recommend it.

IBM Db2 Database

Read 72 IBM Db2 Database reviews

8,041 Views
5,157 Comparison Views

90% willing to recommend

IBM Informix

Read 16 IBM Informix reviews

2,335 Views
1,317 Comparison Views

85% willing to recommend

IBM Db2 Database

IBM Informix

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between IBM Db2 Database and IBM Informix based on real PeerSpot user reviews.

Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed IBM Db2 Database vs. IBM Informix Report (Updated: January 2025).

Buyer's Guide

IBM Db2 Database vs. IBM Informix

January 2025

Download the complete report

Helped 830,633 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

IBM Db2 Database

Ranking in Relational Databases Tools

6th

Average Rating

8.2

Reviews Sentiment

7.0

Number of Reviews

Ranking in other categories

No ranking in other categories

IBM Informix

Ranking in Relational Databases Tools

24th

Average Rating

8.6

Number of Reviews

Ranking in other categories

Embedded Database (9th)

Mindshare comparison

As of January 2025, in the Relational Databases Tools category, the mindshare of IBM Db2 Database is 7.2%, up from 6.5% compared to the previous year. The mindshare of IBM Informix is 1.8%, up from 1.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Relational Databases Tools

Featured Reviews

SimonHiggins

Mainframe Technical Manager/Service Integration Lead at Saudi Business Machines

Very scalable with high availability and excellent technical support

The good thing is that there are improvements coming with later function levels for the z/OS Db2. I'd like it if, with the operating system that we've got, z/OS, on the mainframe, it would allow us to refresh the hardware to run Linux dockers on the mainframe. This means this might give us opportunities for different ways of coming into the Db2 environment in the future. We just want a bit more integration with Linux. That said, we are already seeing Linux more readily available on the mainframe environment. Not only have we got the premium operating systems on OS. We can run LPARs on the same mainframe footprint that is also supporting Linux. This is what has improved and made the mainframe environment more competitive. We're also looking at AI for Db2 as well, and machine learning for the future. We know that AI has come out, that we're going to get that, and we're going to evaluate that product next year for Db2. That said, I haven't got any real complaints about Db2 on the mainframe. For the most part, a lot of the problems we have nowadays are to do with communication between the various teams that you would class as stakeholders.

Read full review

Nazzareno Maria Rezzini

Senior Oracle Database and Systems Administrator at Dedagroup

Supports multiple business intelligence tools, but the technical support services need improvement

IBM Informix is a central database solution across various environments, supporting multiple applications and business intelligence tools The key areas for improvement revolve around understanding the current customer trends and demands, particularly in software and database requirements. The…

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"Scales well enough for a relational database."

"Scalability-wise, I rate the solution a nine out of ten."

"The most valuable feature is PowerPC support."

"The solution is stable."

"It's a very mature product."

"The solution has very good data compression of up to 50%. For example, if you have 50 terabytes of data, it can be reduced to 25 terabytes."

"it is very stable and runs smoothly once it is deployed and it is almost maintenance-free."

"The most valuable feature of IBM Db2 Database is its ability to perform automatic self-management, reducing the need for manual tasks such as managing logs and folders."

More IBM Db2 Database pros

"It supports multiple applications and business intelligence tools."

"Replication is a valuable feature and easy to use."

"This solution has made financial reporting possible by allowing financial people the opportunity to set Informix to "Auto Pilot" so that they can attend other duties."

"So far, we do not have a lot of issues. It's pretty problem-free."

"For IoT business cases, having Informix Enterprise Edition work on edge computers, like Raspberry Pi and using Informix replication, makes complex situations simple to build and maintain."

"The solution's stability, performance, enhanced functionality, and replication are all great features."

"The initial setup is pretty easy."

"The most valuable feature is concurrency and locking because my customers usually use databases in OLTP mode. So, for a large number of competitive users. Other features that are well valued are quick large-scale data types. It is better than Oracle."

More IBM Informix pros

Cons

"Its process of building up queries could be more accessible."

"The initial set up was complex."

"The queries can be difficult for beginners because there are so many. I would like to see more use cases for flow analysis that enable us to correlate the flow with events. Adding this feature in a QI format would be good for beginners."

"IBM Db2 Database could improve the user-defined functions. There are some user-defined functions that are missing, such as the spring functions. I used to have Teradata for my projects and I was used to working in the environment. They had a good set of user-defined functions."

"The application development requires a Java developer and not every company has these resources."

"They should simplify the management of Db2 as a relational database system. There should be the simplification of management. This is probably one of the most important asks for being successful in the future."

"I would like to see some artificial intelligence brought into the solution."

"The user interface is not user-friendly."

More IBM Db2 Database cons

"This product could be made easier to use for beginners."

"There should be more intelligence surrounding discovering data to be able to automatically create indexes."

"I really would love to have a QT plugin."

"Continue extending the SQL language for compatibility with the competition's language, including Stored Procedure Language."

"I experienced poor input/output (IO) performance."

"The solution really doesn't add new features very often."

"I would like to see backups from secondary servers."

"This solution is in need of more current tools."

More IBM Informix cons

Pricing and Cost Advice

"The solution's pricing is fine."

"The solution costs less than other products."

"It is expensive."

"Compared to other databases, Db2 is relatively cheaper."

"Clients are required to purchase a license."

"We did not buy it. It came with our hardware without any complimentary maintenance. If I compare Db2 Database with Oracle Database, its price is lower than Oracle Database."

"It is expensive. The price depends on the size of the machine on which you are installing the Db2 and the features you are using. It also depends on the country. IBM has different policies and different options for payment for this product."

"We don't see what the specific price of the DB2 license is because we pay for the backup license as a package."

More IBM Db2 Database pricing and cost advice

"For me, it's always too expensive."

"The free edition can be enough to handle moderate-size implementations, but you may want a pay for edition to benefit from more functionality, such as replication."

"The product has reasonable pricing. We purchase its yearly license."

"I am not aware of the licensing costs or terms."

See which vendors are best for you

Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.

See recommendations

830,633 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Educational Organization

61%

Financial Services Firm

Computer Software Company

Manufacturing Company

Educational Organization

65%

Financial Services Firm

Computer Software Company

Retailer

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about IBM Db2 Database?

Db2 database scalability and performance capabilities match our database needs. It covers pretty much everything a database administrator or engineer might need.

See all answers

What is your experience regarding pricing and costs for IBM Db2 Database?

IBM Db2 is an expensive solution. While I am not heavily involved with pricing, additional companies provide capabilities or products like those from BMC, which many installations might also purchase.

See all answers

What needs improvement with IBM Db2 Database?

The usage of Db2 could be simplified, as it is quite complex and requires substantial knowledge of Db2 and zOS. Modern features are being implemented, but further simplification and the inclusion o...

See all answers

What do you like most about IBM Informix?

It supports multiple applications and business intelligence tools.

See all answers

What is your experience regarding pricing and costs for IBM Informix?

The product has reasonable pricing. We purchase its yearly license.

See all answers

What needs improvement with IBM Informix?

The key areas for improvement revolve around understanding the current customer trends and demands, particularly in software and database requirements. The product's performance could be better com...

See all answers

Comparisons

SQL Server vs IBM Db2 Database

Compared 33% of the time

Oracle Database vs IBM Db2 Database

Compared 19% of the time

SAP HANA vs IBM Db2 Database

Compared 17% of the time

Teradata vs IBM Db2 Database

Compared 12% of the time

Oracle Database In-Memory vs IBM Db2 Database

Compared 2% of the time

More IBM Db2 Database Competitors

Oracle Database vs IBM Informix

Compared 37% of the time

SQL Server vs IBM Informix

Compared 32% of the time

MySQL vs IBM Informix

Compared 10% of the time

MariaDB vs IBM Informix

Compared 6% of the time

Teradata vs IBM Informix

Compared 4% of the time

More IBM Informix Competitors

Product Reports

Buyer's Guide

IBM Db2 Database

January 2025

Download IBM Db2 Database product report

Buyer's Guide

IBM Informix

October 2024

Download IBM Informix product report

Also Known As

DB2

Informix

Learn More

IBM

Video not available

IBM

Overview

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 Informix is a widely used and scalable relational database management system designed to handle large amounts of data and high transaction volumes. It is known to provide exceptional performance, thanks to its Parallel Data Query Engine (PDQ) that enables parallel processing of queries and operations, significantly reducing response times for complex queries and large data sets. Additionally, Informix supports online operations like backup, restore, index maintenance, and table reorganization, minimizing downtime and ensuring continuous availability.

Informix provides robust high availability and replication features, including shared-disk clustering, remote data replication, and high-availability data replication (HDR). These features ensure data redundancy, failover protection, and disaster recovery capabilities, making it a reliable choice for mission-critical applications. Furthermore, Informix offers specialized features for data warehousing and analytics, such as in-database analytics, data compression, and parallel load capabilities, making it suitable for business intelligence (BI) and data analysis applications.

Informix can be deployed as an embedded database, allowing it to be tightly integrated with applications and systems, reducing overhead and simplifying deployment. It includes workload management capabilities, enabling organizations to prioritize and manage different types of workloads, such as online transaction processing (OLTP) and analytical queries, ensuring efficient resource utilization and meeting service-level agreements (SLAs). Informix also provides robust security features, including role-based access control, data encryption, auditing, and compliance with industry standards like FIPS 140-2 and Common Criteria.

Sample Customers

Knorr-Bremse, Mizuho Bank Ltd., Australian Government Department of Defence, SCHWENK Zement, Friedhelm Loh Group, YAZAKI Europe Limited, Ekornes ASA, Baldor Electric, VSN Systemen BV, Lion Brewery (Ceylon) PLC, PLANSEE Group, TE Connectivity, Hansgrohe SE, Openmatics, University of Toronto

Shaspa, Hildebrand, Kaifa, Ranhill Powertron, Federaci‹ Farmacutica (FedeFarma), Camden Council, The German Aerospace Center (DLR), Myers, Votorantim Group, Doosan Infracore, GreenIvory

Buyer's Guide

IBM Db2 Database vs. IBM Informix

January 2025

Free Report: IBM Db2 Database vs. IBM Informix

Find out what your peers are saying about IBM Db2 Database vs. IBM Informix and other solutions. Updated: January 2025.

DOWNLOAD NOW

830,633 professionals have used our research since 2012.

See our IBM Db2 Database vs. IBM Informix report.

See our list of best Relational Databases Tools vendors.

We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.