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."When you submit a ticket the response time is quick."
"The most valuable features of this solution are security and stability."
"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 most valuable feature of the IBM Db2 Database is security."
"The most valuable feature is PowerPC support."
"Very good for performance and scalability."
"Db2 database scalability and performance capabilities match our database needs. It covers pretty much everything a database administrator or engineer might need."
"Db2 Database has given us good results since we have started to use it. We predominantly use IBM hardware, and this is one of the reasons why we started to use Db2 Database. Db2 Database has a very good HADR capability. High availability resilience is also good in this solution. It also has pureScale, which allows you to upgrade one node to get very good and high-level resilience. If you are using a database on five nodes, you can take one node down, upgrade that, and let that node up. You can then bring the second node down, upgrade that, and so on."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"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."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"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."
"Unbeatable speed and compression with a colummn-structured relational database."
"End-to-end encryption specifically is something the solution needs to have in the next release."
"Do not use support. Freely available documentation is a bit weak."
"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 GUI interface is not particularly friendly for those who do not have experience with the product."
"IBM's products tend to be quite costly, especially given the availability of free, open-source alternatives."
"It would be helpful to have a hybrid data storage facility that includes NoSQL technologies."
"When I look at Microsoft SQL Server, SQL Server provides me with better tools for database management."
"IBM Db2 Database could improve the user-defined functions. There are some user-defined functions that are missing, such as the spring functions. I used to have Teradata for my projects and I was used to working in the environment. They had a good set of user-defined functions."
"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."
"Concurrency and functional error messaging."
"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."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
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.