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 solution can scale."
"Scalability-wise, I rate the solution a nine out of ten."
"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."
"The most valuable feature of the solution is its compatibility with IBM Power Systems."
"The self-management and optimization features are probably the best on the market"
"The most valuable feature is PowerPC support."
"The solution is very stable, in both hardware and database."
"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."
"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."
"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."
"IBM Informix benefits users with high availability and good integration capabilities."
"The initial setup is pretty easy."
"The solution's stability, performance, enhanced functionality, and replication are all great features."
"The scalability is very good."
"Replication, all levels of replication, query charting, and the MongoDB embedded are the most valuable features of this solution."
"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."
"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."
"Not very solid compared to its competitors' products."
"The solution could be more modern and have updated database technology."
"There are some issues with Db2's database file system not being readable. The storage could also be increased, and the monitoring could be improved."
"It would be helpful to have more querying tools and more development tools for us to work easily with Microsoft."
"Also, the website could be more intuitive. I didn't find it easy to find documentation on the website."
"In terms of improvements, IBM Db2 can improve its interface and its functionality. Also, the embedded functions should be much richer than the current ones - the functions which are embedded in the engine itself."
"The management of Db2 should be simplified because there are not too many specialists in this area, and the learning curve of Db2 specialists is very long. After the courses, probably it takes one and a half or two years to get to the point when you are using the product properly in the production systems. So, the complexity is very high, and the most important thing is to simplify the management of the product, including self-maintenance. They should simplify the installation, management, and monitoring to simplify the product. It takes too long for a person to be a specialist in this product."
"The technical support services need substantial improvement."
"I would like to see backups from secondary servers."
"Continue extending the SQL language for compatibility with the competition's language, including Stored Procedure Language."
"There should be more intelligence surrounding discovering data to be able to automatically create indexes."
"This product could be made easier to use for beginners."
"The pricing is a bit expensive."
"The solution really doesn't add new features very often."
"It would be helpful to have IBM salespeople know that Informix exists, and sell it. Currently, it is completely ignored by IBM."
IBM Db2 Database is ranked 6th in Relational Databases Tools with 67 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.