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."The most valuable aspect of this solution is its stability. We have never had any problems and have never had to contact technical support."
"It's easy to search and extract data from the warehouse using queries."
"It's the best solution in terms of security, performance, and availability because the system is available 24/7."
"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."
"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."
"It's a very mature product."
"I believe that because the support is good, they jump in and assist us in determining the root cause."
"The newly added feature of ALSM is one of the top features"
"It supports in-house-built applications in .NET and VB6"
"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."
"The scalability is very good."
"So far, we do not have a lot of issues. It's pretty problem-free."
"The initial setup is pretty easy."
"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."
"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 initial set up was complex."
"The GUI interface is not particularly friendly for those who do not have experience with the product."
"I would say that the tool has to be made more cloud-friendly and should have agreements with AWS, Microsoft, or Google to run things on hyperscalers."
"The technical support team is not very good when compared to the efficiency of Oracle's support."
"Microsoft SQL Server is comparatively very simple to use. I wish IBM would move towards making Db2 easy to use for both basic and advanced users. This is where I see room for advancement. Db2 is also more expensive than Microsoft SQL Server, and its price can be reduced. The replication feature needs to be there in Db2. Microsoft provides similar functionality in SQL Server. IBM also has similar functionality, but it exists in a different product. So, to have the replication ability, you have to buy a different product. It makes sense to have this functionality within Db2 instead of a different product. It will also be helpful in terms of competition. In Africa, the problem for Db2 is competition. Oracle Database and Microsoft SQL Server have been in this market for a very long time. These companies have built the ecosystem and the brand within this market for a very long time. So, they are very popular with users. Db2 or IBM came a little later in the game, and that's where the problem lies. They also don't do a lot of marketing for it, which is also a problem."
"There could be better integration with some cloud solutions."
"The capabilities of this solution could improve."
"The technical support services need substantial improvement."
"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 pricing is a bit expensive."
"The solution lacks some functionality."
"It would be helpful to have IBM salespeople know that Informix exists, and sell it. Currently, it is completely ignored by IBM."
"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."
IBM Db2 Database is ranked 6th in Relational Databases Tools with 67 reviews while IBM Informix is ranked 15th in Relational Databases Tools with 16 reviews. IBM Db2 Database is rated 8.2, while IBM Informix is rated 8.6. 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 "Quite stable and flexible but not very innovative". IBM Db2 Database is most compared with SQL Server, Oracle Database, SAP HANA, Teradata and IBM Netezza Performance Server, whereas IBM Informix is most compared with Oracle Database, SQL Server, MySQL, MariaDB and Teradata. 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.
