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.2, while IBM Informix is ranked #23 with an average rating of 6.5. IBM Db2 Database holds a 7.3% mindshare in SQL, compared to IBM Informix’s 1.7% 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,947 Views
5,870 Comparison Views

90% willing to recommend

IBM Informix

Read 16 IBM Informix reviews

2,519 Views
1,460 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: October 2024).

Buyer's Guide

IBM Db2 Database vs. IBM Informix

October 2024

Download the complete report

Helped 816,562 peers since 2012

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

23rd

Average Rating

8.6

Number of Reviews

Ranking in other categories

Embedded Database (8th)

Mindshare comparison

As of November 2024, in the Relational Databases Tools category, the mindshare of IBM Db2 Database is 7.3%, up from 6.5% compared to the previous year. The mindshare of IBM Informix is 1.7%, up from 1.7% 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

"The most valuable features are with the industrial side."

"The newly added feature of ALSM is one of the top features"

"The most valuable feature of the IBM Db2 Database is security."

"The solution helps secure the database."

"It's the best solution in terms of security, performance, and availability because the system is available 24/7."

"The initial setup was easy."

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

"As part of your licensing with IBM, you get access to their case system, which lets you raise incidents related to software or hardware. This system is helpful for problem determination and quickly identifying issues."

More IBM Db2 Database pros

"Every version is faster than the previous."

"It supports multiple applications and business intelligence tools."

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

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

"The stability is incredible. I have customers with uptimes of several years."

"IBM Informix benefits users with high availability and good integration capabilities."

"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 initial setup is pretty easy."

More IBM Informix pros

Cons

"Some of the internal rearrangement in the administration is not as straightforward as it is in competing products."

"IBM Db2 Database could improve with better security."

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

"It would be ideal if the solution offered backup functionality. Many similar tools already do, which means Db2 is somewhat behind the curve in terms of what a customer might expect from it."

"The pricing could be improved, it's expensive."

"The user interface is not user-friendly."

"The solution's UI hasn't been upgraded. The solution’s UI is an area to improve because the solution was developed long ago."

"Do not use support. Freely available documentation is a bit weak."

More IBM Db2 Database cons

"The technical support services need substantial improvement."

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

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

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

"In my opinion, the packages could be improved. The version I use doesn't allow for packages. I can do some general procedures, but no packages like in Oracle. So, develop separate modules in SQL language. This would be most beneficial for me."

"The support team could include local engineers to establish efficient communication. It will help us speed up the escalation process."

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

"It would be helpful to have IBM salespeople know that Informix exists, and sell it. Currently, it is completely ignored by IBM."

More IBM Informix cons

Pricing and Cost Advice

"I would rate the pricing a five out of ten. It's not super expensive, but also not cheap."

"The total cost of the solution depends upon the PVU licensing"

"I rate the product pricing a nine out of ten."

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

"We purchase the product's yearly license."

"It's very expensive."

"The solution costs less than other products."

"They are competitive and honest (compared to how peer firms approach licensing conversations). "

More IBM Db2 Database pricing and cost advice

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

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

"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

816,562 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Educational Organization

60%

Financial Services Firm

Computer Software Company

Manufacturing Company

Educational Organization

64%

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 31% of the time

Oracle Database vs IBM Db2 Database

Compared 20% of the time

SAP HANA vs IBM Db2 Database

Compared 16% of the time

Teradata vs IBM Db2 Database

Compared 11% of the time

MariaDB vs IBM Db2 Database

Compared 1% of the time

More IBM Db2 Database Competitors

Oracle Database vs IBM Informix

Compared 36% of the time

SQL Server vs IBM Informix

Compared 33% of the time

MySQL vs IBM Informix

Compared 10% of the time

MariaDB vs IBM Informix

Compared 7% of the time

Teradata vs IBM Informix

Compared 5% of the time

More IBM Informix Competitors

Product Reports

Buyer's Guide

IBM Db2 Database

November 2024

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

October 2024

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: October 2024.

DOWNLOAD NOW

816,562 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.