We changed our name from IT Central Station: Here's why

IBM Db2 Database vs Teradata comparison

Cancel
You must select at least 2 products to compare!
IBM Db2 Database Logo
8,565 views|5,637 comparisons
Teradata Logo
14,030 views|10,796 comparisons
Featured Review
SAMI ABOU KARAM
Use Teradata? Share your opinion.
Find out what your peers are saying about IBM Db2 Database vs. Teradata and other solutions. Updated: January 2022.
564,143 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"Reliable, robust with great features.""We are dealing with millions of transactions a month and the performance is very good.""IBM Db2 was much cheaper as a package than using other products. This is because IBM supplied a package with its product. It's an application. So it was much more efficient and a stronger competitor in that regard.""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.""Very good for performance and scalability.""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.""it is very stable and runs smoothly once it is deployed and it is almost maintenance-free.""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."

More IBM Db2 Database Pros →

"The flexibility in design is very good.""The functionality of the solution is excellent.""Teradata features high productivity and reliability because it has several redundancy options, so the system is always up and running.""Teradata has good performance, the response times are very fast. Overall the solution is easy to use. When we do the transformation, we have all of our staging and aggregation data available.""I like this solution's ease of design and the fact that its performance is quite good. It is stable as well.""It's a pre-configured appliance that requires very little in terms of setting-up.""The performance is great, we are able to query our data in one operation."

More Teradata Pros →

Cons
"They should simplify the management of Db2 as a relational database system. There should be the simplification of management. This is probably one of the most important asks for being successful in the future.""The technical support team is not very good when compared to the efficiency of Oracle's support.""GUI needs improvement.""There could be better integration with some cloud solutions.""The capabilities of this solution could improve.""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 be more modern and have updated database technology.""Performance is something that can be improved with DB2."

More IBM Db2 Database Cons →

"The solution is stable. However, there are times when we are using large amounts of data and we can see some latency issues.""The scalability could be better. The on-premises solution is always more complicated to scale.""Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve.""I'm not sure about the unstructured data management capabilities. It could be improved.""I would like to see more integration with many different types of data.""It could use some more advanced analytics relating to structured and semi-structured data.""Teradata needs to expand the kind of training that's available to customers. Teradata only offers training directly and doesn't delegate to any third-party companies. As a result, it's harder to find people trained on Teradata in our market relative to Oracle."

More Teradata Cons →

Pricing and Cost Advice
  • "Db2 is less expensive than Oracle."
  • "We did not buy it. It came with our hardware without any complimentary maintenance. If I compare Db2 Database with Oracle Database, its price is lower than Oracle Database."
  • "There is a license for this solution and we pay every three years."
  • "Among Microsoft SQL Server, Oracle, and Db2, Microsoft SQL Server is the cheapest one, and Oracle is the most expensive one. Db2 is in the middle. As compared to SQL Server, its price could go down. It will be good for customers."
  • "We normally handle large size businesses and as far as I am aware, the license is negotiable based on the number of users and the quantitative data."
  • "It is expensive."
  • More IBM Db2 Database Pricing and Cost Advice →

  • "The solution requires a license."
  • "The price of Teradata is on the higher side, and I think that it where they lose out on some of their business."
  • "The price of the solution could be reduced, it is expensive."
  • "Teradata is expensive, so it's typically marketed to big customers. However, there have been some changes, and Teradata is now offering more flexible pricing models and equipment leasing. They've added pay-as-you-go and cloud models, so it's changing, but Teradata is generally known as an expensive high-end product."
  • More Teradata Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Relational Databases solutions are best for your needs.
    564,143 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: 
    DB2 versus Oracle: - Table structure is different - Data structures - there are some differences including the data type, format and length.
    Top Answer: 
    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… more »
    Top Answer: 
    In the 90s, there was a big problem with the IBM mainframe environment and there was a big push to move the middleware off the mainframe and put it on cheaper distributed hardware. What happened then… more »
    Top Answer: 
    Teradata has good performance, the response times are very fast. Overall the solution is easy to use. When we do the transformation, we have all of our staging and aggregation data available.
    Top Answer: 
    Teradata could improve by providing better training. For example, Oracle provides good overall training. It is not easy to find information on the internet.
    Top Answer: 
    We use Teradata in our data warehouse and we extract data. We have a data department that uses many tools for data extractions.
    Ranking
    5th
    Views
    8,565
    Comparisons
    5,637
    Reviews
    15
    Average Words per Review
    772
    Rating
    8.0
    6th
    Views
    14,030
    Comparisons
    10,796
    Reviews
    5
    Average Words per Review
    421
    Rating
    8.4
    Comparisons
    Also Known As
    DB2
    Learn More
    Overview
    DB2 Enterprise for Linux, UNIX, and Windows is the ideal data server for the most demanding workloads. New XML support is designed to help firms minimize the time and effort it takes to persist and use their XML data reducing development costs and improving business agility.

    Teradata's portfolio of big data analytic solutions, integrated marketing applications, and services help organizations gain a sustainable competitive advantage with data.

    Offer
    Learn more about IBM Db2 Database
    Learn more about Teradata
    Sample Customers
    Knorr-Bremse, Mizuho Bank Ltd., Australian Government Department of Defence, SCHWENK Zement, Friedhelm Loh Group, YAZAKI Europe Limited, Ekornes ASA, Baldor Electric, VSN Systemen BV, Lion Brewery (Ceylon) PLC, PLANSEE Group, TE Connectivity, Hansgrohe SE, Openmatics, University of Toronto
    Netflix
    Top Industries
    REVIEWERS
    Financial Services Firm43%
    Insurance Company13%
    Computer Software Company9%
    Manufacturing Company9%
    VISITORS READING REVIEWS
    Computer Software Company28%
    Comms Service Provider17%
    Financial Services Firm10%
    Insurance Company7%
    REVIEWERS
    Comms Service Provider31%
    Energy/Utilities Company15%
    Computer Software Company15%
    Financial Services Firm8%
    VISITORS READING REVIEWS
    Computer Software Company30%
    Comms Service Provider15%
    Financial Services Firm12%
    Manufacturing Company5%
    Company Size
    REVIEWERS
    Small Business27%
    Midsize Enterprise10%
    Large Enterprise63%
    REVIEWERS
    Small Business31%
    Midsize Enterprise10%
    Large Enterprise59%
    Find out what your peers are saying about IBM Db2 Database vs. Teradata and other solutions. Updated: January 2022.
    564,143 professionals have used our research since 2012.

    IBM Db2 Database is ranked 5th in Relational Databases with 15 reviews while Teradata is ranked 6th in Relational Databases with 7 reviews. IBM Db2 Database is rated 8.0, while Teradata is rated 8.4. 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 "Good performance, flexible, easy to tune queries, and scales well". IBM Db2 Database is most compared with Oracle Database, SQL Server, MySQL, SAP HANA and IBM Netezza Performance Server, whereas Teradata is most compared with Oracle Exadata, Snowflake, SQL Server, Amazon Redshift and SAP HANA. See our IBM Db2 Database vs. Teradata report.

    See our list of best Relational Databases vendors.

    We monitor all Relational Databases 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.