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."We had a crash of the backup system and the IBM DB2 was always up and consistent. It's robust, and for us, it was always up and running."
"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's a very mature product."
"The stability of IBM Db2 Database is stable. We have not faced any downtime in one year. Our work is mostly during business hours and during that time, we haven't faced any downtime."
"The scalability and availability of this solution are the most valuable features."
"Reliable, robust with great features."
"The most valuable aspect of this solution is its stability. We have never had any problems and have never had to contact technical support."
"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."
"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."
"Replication is a valuable feature and easy to use."
"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."
"It supports multiple applications and business intelligence tools."
"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."
"So far, we do not have a lot of issues. It's pretty problem-free."
"Replication, all levels of replication, query charting, and the MongoDB embedded are the most valuable features of this solution."
"The solution's stability, performance, enhanced functionality, and replication are all great features."
"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."
"The capabilities of this solution could improve."
"We need some time to improve the performance. We have to perform a weekly REORG, or else RUNSTATS for the databases."
"The product’s user interface is not easy to use."
"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."
"The licensing fees can be reduced."
"The technical support can be faster."
"The pricing is a bit expensive."
"I really would love to have a QT plugin."
"The support team could include local engineers to establish efficient communication. It will help us speed up the escalation process."
"There should be more intelligence surrounding discovering data to be able to automatically create indexes."
"The technical support services need substantial improvement."
"The solution lacks some functionality."
"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."
"I experienced poor input/output (IO) performance."
IBM Db2 Database is ranked 6th in Relational Databases Tools with 66 reviews while IBM Informix is ranked 14th 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.