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."It has a good feature called pureScale, which is just for scalability. It is a perfect solution for environments where scalability is going to be an issue."
"Db2's best features are that it's self-maintaining and self-monitoring, which means I have to view and monitor the database far less often."
"IBM Db2 Database has good performance."
"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."
"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."
"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."
"Db2 database scalability and performance capabilities match our database needs. It covers pretty much everything a database administrator or engineer might need."
"The most valuable feature of the IBM Db2 Database is security."
"The scalability is very good."
"The solution's stability, performance, enhanced functionality, and replication are all great features."
"It supports multiple applications and business intelligence tools."
"Replication is a valuable feature and easy to use."
"Every version is faster than the previous."
"Replication, all levels of replication, query charting, and the MongoDB embedded are the most valuable features of this solution."
"So far, we do not have a lot of issues. It's pretty problem-free."
"It supports in-house-built applications in .NET and VB6"
"End-to-end encryption specifically is something the solution needs to have in the next release."
"IBM Db2 Database is not ACID compliant, which would improve it. Db2 lacks Isolation, so when two people are trying to update the same field at the same time it can become stuck. Other newer databases do not have this issue, such as Microsoft SQL, Oracle DB, PostgreSQL, and SAP HANA."
"The technical support team is not very good when compared to the efficiency of Oracle's support."
"The product needs to improve its configuration and storage."
"The initial set up was complex."
"The technical support can be faster."
"It would be helpful to have more querying tools and more development tools for us to work easily with Microsoft."
"The licensing fees can be reduced."
"It would be helpful to have IBM salespeople know that Informix exists, and sell it. Currently, it is completely ignored by IBM."
"The solution lacks some functionality."
"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."
"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."
"This solution is in need of more current tools."
"Continue extending the SQL language for compatibility with the competition's language, including Stored Procedure Language."
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 Oracle Database In-Memory, 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.