We performed a comparison between IBM Db2 Database and Teradata 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."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 most valuable feature is PowerPC support."
"We are dealing with millions of transactions a month and the performance is very good."
"It has a good, stable performance."
"IBM Db2 Database has good performance."
"The solution has many beneficial features, such as security, support, and stability."
"It's the best solution in terms of security, performance, and availability because the system is available 24/7."
"The performance of the solution is valuable."
"The ability to handle machine data parallel processing is the most valuable feature of Teradata."
"Their extensive experience in data warehousing, the platform's performance, and their strong reputation in the market are the most valuable."
"The most valuable feature of Teradata is security. It runs on Unix and Linux platforms which provide better security."
"Viewpoint, the detailed query logs and performance statistics are valuable features."
"It has given our business the ability to gain insights into the data and create data labs for analysis and PoCs."
"Designing the database is easy."
"Teradata solutions help organizations reduce IT, operations, and maintenance costs; enhance on-time delivery of products and services."
"The most valuable features are the large volume of data and the structuring of the data to optimize it and get very optimal data warehouse solutions for customers."
"We just want a bit more integration with Linux. That said, we are already seeing Linux more readily available on the mainframe environment."
"The capabilities of this solution could improve."
"The technical support can be faster."
"The pricing could be improved, it's expensive."
"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."
"The product needs to improve its configuration and storage."
"We need some time to improve the performance. We have to perform a weekly REORG, or else RUNSTATS for the databases."
"Also, the website could be more intuitive. I didn't find it easy to find documentation on the website."
"We tried to use case Teradata for a data warehouse system, but we had some problems in relation to the Teradata system, CDC tools, and source databases. We were unable to transfer data from HPE Integrity mainframe to Teradata."
"The current operational approach needs improvement."
"It could use some more advanced analytics relating to structured and semi-structured data."
"I'm not sure about the unstructured data management capabilities. It could be improved."
"Data synchronization to the DR site."
"Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly."
"The solution could improve by having a cloud version or a cloud component. We have to use other solutions, such as Amazon AWS, Microsoft Azure, or Snowflake for the cloud."
"The following could be better: licensing, architecture openness, integration with other tools."
IBM Db2 Database is ranked 6th in Relational Databases Tools with 67 reviews while Teradata is ranked 7th in Relational Databases Tools with 54 reviews. IBM Db2 Database is rated 8.2, while Teradata is rated 8.2. 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 Teradata writes "Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities". IBM Db2 Database is most compared with SQL Server, Oracle Database, SAP HANA, MySQL and Oracle Database In-Memory, whereas Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, MySQL and Amazon Redshift. See our IBM Db2 Database vs. Teradata 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.