We changed our name from IT Central Station: Here's why

IBM Db2 Database vs IBM Informix comparison

Cancel
You must select at least 2 products to compare!
IBM Db2 Database Logo
8,565 views|5,637 comparisons
IBM Informix Logo
2,126 views|1,322 comparisons
Featured Review
Find out what your peers are saying about IBM Db2 Database vs. IBM Informix and other solutions. Updated: January 2022.
563,780 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The solution is a very stable relational database and has integration with legacy systems. It is a great product.""Its robustness, scalability, availability, and performance are valuable. All these are the major attributes of a relational database for supporting a very high-volume business, and Db2 is very good in all those areas and in all those attributes.""IBM Db2 Database has good performance.""Your iOS, your throughputs, your performance cycles, you cannot touch it with Microsoft or with Oracle scalability-wise. That is far and away the most scalable systems and the highest performing systems of the set of them.""Very good for performance and scalability.""Reliable, robust with great features.""The most valuable feature is PowerPC support.""I like that its true active-active. For example, if there are two instances within a cluster, we can take one of them down and there's no failover or switch over. There's no primary and secondary, it's true active-active. We can take one side down and we can upgrade that with new maintenance or a new version, obviously testing coexistence beforehand, without impacting the business."

More IBM Db2 Database Pros →

"The scalability is very good.""Replication is a valuable feature and easy to use.""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 stability is incredible. I have customers with uptimes of several years.""The initial setup is pretty easy.""The solution's stability, performance, enhanced functionality, and replication are all great features.""So far, we do not have a lot of issues. It's pretty problem-free."

More IBM Informix Pros →

Cons
"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.""The solution could improve by providing more integration.""We just want a bit more integration with Linux. That said, we are already seeing Linux more readily available on the mainframe environment.""GUI needs improvement.""Their view of it is they're maintaining it, they're continuing to upgrade it, they're continuing to grow it, however, they don't go out and try and sell that as an architectural solution the way they do Linux and Unix.""The only drawback that we see in Db2 Database is the crash recovery. When there is a crash and somebody has to do the recovery, Db2 Database first stops, and then it does any crash recovery. In Oracle Database, crash recovery happens within the database. The database is not shut down.""Performance is something that can be improved with DB2.""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."

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.""The solution really doesn't add new features very often.""The solution lacks some functionality.""The pricing is a bit expensive.""Continue extending the SQL language for compatibility with the competition's language, including Stored Procedure Language.""I would like to see backups from secondary servers."

More IBM Informix Cons →

Pricing and Cost Advice
  • "Db2 is less expensive than Oracle."
  • "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."
  • "There is a license for this solution and we pay every three years."
  • "Among Microsoft SQL Server, Oracle, and Db2, Microsoft SQL Server is the cheapest one, and Oracle is the most expensive one. Db2 is in the middle. As compared to SQL Server, its price could go down. It will be good for customers."
  • "We normally handle large size businesses and as far as I am aware, the license is negotiable based on the number of users and the quantitative data."
  • "It is expensive."
  • More IBM Db2 Database Pricing and Cost Advice →

  • "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."
  • More IBM Informix Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Relational Databases solutions are best for your needs.
    563,780 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: 
    DB2 versus Oracle: - Table structure is different - Data structures - there are some differences including the data type, format and length.
    Top Answer: 
    I like that its true active-active. For example, if there are two instances within a cluster, we can take one of them down and there's no failover or switch over. There's no primary and secondary… more »
    Top Answer: 
    In the 90s, there was a big problem with the IBM mainframe environment and there was a big push to move the middleware off the mainframe and put it on cheaper distributed hardware. What happened then… more »
    Top Answer: 
    I would like to see backups from secondary servers.
    Ranking
    5th
    Views
    8,565
    Comparisons
    5,637
    Reviews
    15
    Average Words per Review
    772
    Rating
    8.0
    8th
    Views
    2,126
    Comparisons
    1,322
    Reviews
    6
    Average Words per Review
    594
    Rating
    9.0
    Comparisons
    Also Known As
    DB2
    Informix
    Learn More
    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.
    Informix is one of the most widely used database servers offering high levels of performance and availability, distinctive capabilities, & minimal overhead.
    Offer
    Learn more about IBM Db2 Database
    Learn more about IBM Informix
    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‹ Farmacutica (FedeFarma), Camden Council, The German Aerospace Center (DLR), Myers, Votorantim Group, Doosan Infracore, GreenIvory
    Top Industries
    REVIEWERS
    Financial Services Firm43%
    Insurance Company13%
    Computer Software Company9%
    University9%
    VISITORS READING REVIEWS
    Computer Software Company28%
    Comms Service Provider17%
    Financial Services Firm10%
    Insurance Company7%
    VISITORS READING REVIEWS
    Computer Software Company32%
    Comms Service Provider23%
    Government7%
    Retailer6%
    Company Size
    REVIEWERS
    Small Business27%
    Midsize Enterprise10%
    Large Enterprise63%
    REVIEWERS
    Small Business58%
    Midsize Enterprise8%
    Large Enterprise33%
    Find out what your peers are saying about IBM Db2 Database vs. IBM Informix and other solutions. Updated: January 2022.
    563,780 professionals have used our research since 2012.

    IBM Db2 Database is ranked 5th in Relational Databases with 15 reviews while IBM Informix is ranked 8th in Relational Databases with 8 reviews. IBM Db2 Database is rated 8.0, while IBM Informix is rated 9.2. The top reviewer of IBM Db2 Database writes "Very scalable with high availability and excellent technical support". On the other hand, the top reviewer of IBM Informix writes "Many embedded functionalities of the engine allow for significant savings on complex developments and maintenance". IBM Db2 Database is most compared with Oracle Database, SQL Server, MySQL, SAP HANA and Oracle Multitenant, whereas IBM Informix is most compared with SQL Server, Oracle Database, MySQL, Oracle Database In-Memory and Oracle Multitenant. See our IBM Db2 Database vs. IBM Informix report.

    See our list of best Relational Databases vendors.

    We monitor all Relational Databases 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.