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 most valuable feature of the solution is its compatibility with IBM Power Systems."
"Some of the most valuable features are the scaling from a small very cheap installation to a very large enterprise installation. In addition, the backups and assistance are good."
"The solution helps secure the database."
"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."
"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 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."
"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 features are the simplicity of the database and the access to Db2 and Db2 information."
"Columnar storage allows high compression, high load rates and high query performance."
"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."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"Unbeatable speed and compression with a colummn-structured relational database."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"When I look at Microsoft SQL Server, SQL Server provides me with better tools for database management."
"We just want a bit more integration with Linux. That said, we are already seeing Linux more readily available on the mainframe environment."
"The ease of use, or ease of management, could be improved."
"IBM's products tend to be quite costly, especially given the availability of free, open-source alternatives."
"There could be better integration with some cloud solutions."
"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 initial setup could be improved."
"There could be more user-friendly tools with features such as drag-and-drop functionality, visual basics, and low-code capabilities."
"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 organization who owns the product does not support it well and appears not to be doing significant development for the future."
"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 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."
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, SQL Server, SAP BW4HANA 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.