IBM Db2 Database vs SAP IQ comparison

"The solution's initial setup is straightforward."

"The newly added feature of ALSM is one of the top features"

"The setup process has become much easier recently."

"The solution is easy to install and simple to maintain. The most valuable aspect of the solution is its general user-friendliness for users of all kinds."

"Its functionality and availability are valuable. Its availability is great. It is available 99.99% of the time."

"I believe that because the support is good, they jump in and assist us in determining the root cause."

"The solution is a very stable relational database and has integration with legacy systems. It is a great product."

"The most valuable feature of the IBM Db2 Database is the ease of use, and the ability to do query writing of any SQL statement and have an output."

"The initial setup is easy."

"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."

"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."

"All data is compressed and indexed, allowing for fast execution of transactions."

"IQ is a very high-performance and high-transaction database."

"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."

"Microsoft SQL Server is comparatively very simple to use. I wish IBM would move towards making Db2 easy to use for both basic and advanced users. This is where I see room for advancement. Db2 is also more expensive than Microsoft SQL Server, and its price can be reduced. The replication feature needs to be there in Db2. Microsoft provides similar functionality in SQL Server. IBM also has similar functionality, but it exists in a different product. So, to have the replication ability, you have to buy a different product. It makes sense to have this functionality within Db2 instead of a different product. It will also be helpful in terms of competition. In Africa, the problem for Db2 is competition. Oracle Database and Microsoft SQL Server have been in this market for a very long time. These companies have built the ecosystem and the brand within this market for a very long time. So, they are very popular with users. Db2 or IBM came a little later in the game, and that's where the problem lies. They also don't do a lot of marketing for it, which is also a problem."

"The solution could improve by providing more integration."

"End-to-end encryption specifically is something the solution needs to have in the next release."

"The vendor should offer a free version"

"I would like to see better support for advanced analytics."

"Performance is something that can be improved with DB2."

"We need some time to improve the performance. We have to perform a weekly REORG, or else RUNSTATS for the databases."

"The queries can be difficult for beginners because there are so many. I would like to see more use cases for flow analysis that enable us to correlate the flow with events. Adding this feature in a QI format would be good for beginners."

"There is very little documentation available."

"The organization who owns the product does not support it well and appears not to be doing significant development for the future."

"I think the universe should be part of the Sybase IQ tool set."

"The primary negative aspect is the cost, which can be a challenge due to the economic conditions in Peru."

"The tool gets stuck sometimes."

"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."

"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."

"It is expensive when compared to other products."

"It's very expensive."

"I would rate the pricing a five out of ten. It's not super expensive, but also not cheap."

"Db2 is less expensive than Oracle."

"The solution's pricing is fine."

"The solution costs less than other products."

"It is expensive."

"We purchase the product's yearly license."

"Negotiation is very important."

"Negotiate based on the features required."

"The cost of implementation is about $3,000."

"It's not that costly. So, the pricing is cheap."

"Evaluate all options; check to see if you need expensive add-ons."

"The only costs after standard licensing fees are for add-ons and upgrades."