We performed a comparison between IBM Db2 Database and SAP IQ 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 is very stable, in both hardware and database."
"The solution can scale."
"Db2 database scalability and performance capabilities match our database needs. It covers pretty much everything a database administrator or engineer might need."
"We are dealing with millions of transactions a month and the performance is very good."
"Its functionality and availability are valuable. Its availability is great. It is available 99.99% of the time."
"The solution is stable."
"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 is PowerPC support."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"Columnar storage allows high compression, high load rates and high query performance."
"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"Unbeatable speed and compression with a colummn-structured relational database."
"The primary benefit of SAP IQ is its ability to limit the expansion of the costly SAP HANA database, which has limited storage capacity. This necessitates a form of data management that involves moving data from SAP HANA to SAP NLS, which is essentially archiving. This allows us to retain access to the data via a link whenever it is required."
"Performance is something that can be improved with DB2."
"The technical support can be faster."
"I would like to see better support for advanced analytics."
"The product needs to improve its configuration and storage."
"There could be more user-friendly tools with features such as drag-and-drop functionality, visual basics, and low-code capabilities."
"The problem with this environment is that any software that you install is very costly because there are no free tools for this environment."
"The licensing fees can be reduced."
"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."
"I think the universe should be part of the Sybase IQ tool set."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"Concurrency and functional error messaging."
"Multiplex is very problematic. There are consistency problems in the metadata, meaning it is possible to lose metadata consistency. You should make sure you have healthy backups."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
IBM Db2 Database is ranked 6th in Relational Databases Tools with 66 reviews while SAP IQ is ranked 21st in Relational Databases Tools with 17 reviews. IBM Db2 Database is rated 8.2, while SAP IQ is rated 8.0. 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 SAP IQ writes "Easy to use, highly stable, but integration could improve". IBM Db2 Database is most compared with SQL Server, Oracle Database, SAP HANA, Teradata and MySQL, whereas SAP IQ is most compared with Snowflake, SAP HANA, SAP BW4HANA, SQL Server and Apache Hadoop. See our IBM Db2 Database vs. SAP IQ 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.