97 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.3 out of 100
37 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

Likelihood to Recommend

DB2

DB2 is suitable for any use. The main one is certainly the creation of an online database that can be queried online through TP queries and through batch reports. It is necessary to take care of the database maintenance to allow maximum performance, for this, there are the utilities that help the system operators to do it.
Anonymous | TrustRadius Reviewer

Teradata Vantage Advanced SQL Engine (Teradata Database)

Teradata query engine is one of the best optimizer.s It's much faster and convenient to develop ETL process with Tetadata since it is designed to work effectively for most of the queries. Teradata provides support for connecting with many different systems to load and transfer terabytes of data efficiently with faster turnaround time.
Anonymous | TrustRadius Reviewer

Pros

DB2

  • DB2 maintains itself very well. The Task Scheduler component of DB2 allows for statistics gathering and reorganization of indexes and tables without user interaction or without specific knowledge of cron or Windows Task Scheduler / Scheduled jobs.
  • Its use of ASYNC, NEARSYNC, and SYNC HADR (High Availability Disaster Recovery ) models gives you a range of options for maintaining a very high uptime ratio. Failover from PRIMARY to SECONDARY becomes very easy with just a single command or windowed mouse click.
  • Task Scheduler ( DB2 9.7 and earlier ) allows for jobs to be run within other jobs, and exit and error codes can define what other jobs are run. This allows for ease of maintenance without third party softwares.
  • Tablespace usage and automatic storage help keep your data segmented while at rest, making partitioning easier.
  • Ability to run commands via CLI (Command Line Interface) or via Control Center / Data Studio ( DB2 10.x+) makes administration a breeze.
J.R. Bullington | TrustRadius Reviewer

Teradata Vantage Advanced SQL Engine (Teradata Database)

  • Teradata database is based on Massively Parallel Processing (MPP) architecture. Because of this architecture, Teradata is able to share the workload evenly across all the system. It splits the work equally to its processes and each process runs in parallel to achieve the result in quickest possible time.
  • The underlying work is done by Teradata nodes, Access Module Processors (AMPs) and the disks associated with AMPs. The beauty is that none of them share any resources which means they all work independently and achieve actual parallel processing with the fastest results. The each AMP shares the same amount of work so that no resource stays idle and the output can be quicker.
  • Another excellent feature of Teradata is the Connectivity portion. It can so easily connect to almost all the major systems like Mainframes, Oracle DB or IBM DB2. The import of loads is super fast and efficient.
  • It is also really helpful when you have to troubleshoot an error because it provides great diagnostic information and therefore saves you a lot of time and effort by not having to go through all the logs manually and find the error and cause for it.
Rahul Malik | TrustRadius Reviewer

Cons

DB2

  • IBM is really behind in delivering developer tools. They pride themselves on Data Studio, but it is just frustrating.
  • Marketing. Horrible to do a Google search and get returns for a COMPLETELY different product, for z/os. Why they share the same name is beyond me. Better marketing would also increase the user base and help the product mature.
  • Slower than the competition to roll out next-generation features.
Anonymous | TrustRadius Reviewer

Teradata Vantage Advanced SQL Engine (Teradata Database)

  • Interface is outdated
  • Some syntax slightly different to standard SQL
  • Needs expertise to best create tables so as to not 'skew' database
David Shi | TrustRadius Reviewer

Likelihood to Renew

DB2

DB2 8.0
Based on 2 answers
Because it is required to support our business unit
Anonymous | TrustRadius Reviewer

Teradata Vantage Advanced SQL Engine (Teradata Database)

Teradata Vantage Advanced SQL Engine (Teradata Database) 10.0
Based on 1 answer
[It's] a must have application in the organisation that cannot be easily replaced.
David Shi | TrustRadius Reviewer

Usability

DB2

DB2 8.0
Based on 3 answers
You have to be well versed in using the technology, not only from a GUI interface but from a command line interface to successfully use this software to its fullest.
J.R. Bullington | TrustRadius Reviewer

Teradata Vantage Advanced SQL Engine (Teradata Database)

Teradata Vantage Advanced SQL Engine (Teradata Database) 9.0
Based on 2 answers
It has helped our project to save time, effort and give accurate results in the quickest possible time. The diagnostics feature is also outstanding giving us a detailed report of the error which occurred, when it occurred and the likely cause and resolution of the same as well. The support of SQL is inherited which makes it easy to work on it because you don't need to learn any new language for this.
Rahul Malik | TrustRadius Reviewer

Reliability and Availability

DB2

DB2 10.0
Based on 20 answers
DB2 for i is extremely stable. I've experienced system slowdowns and performance issues on badly configured systems or badly configured system accessing the DB but that's it, never had a problem caused purely by the software. Support is also pretty good.
Roberto Etcheverry | TrustRadius Reviewer

Teradata Vantage Advanced SQL Engine (Teradata Database)

No score
No answers yet
No answers on this topic

Performance

DB2

DB2 9.9
Based on 20 answers
The performances are exceptional if you take care to maintain the database. It is a very powerful tool and at the same time very easy to use. In our installation, we expect a DB machine on the mainframe with access to the database through ODBC connectors directly from branch servers, with fabulous end users experience.
Anonymous | TrustRadius Reviewer

Teradata Vantage Advanced SQL Engine (Teradata Database)

No score
No answers yet
No answers on this topic

Support Rating

DB2

DB2 8.5
Based on 2 answers
The support experience is good. There is room for improvement in terms of the delivery of support services to customers
Shivani Pandey | TrustRadius Reviewer

Teradata Vantage Advanced SQL Engine (Teradata Database)

Teradata Vantage Advanced SQL Engine (Teradata Database) 8.0
Based on 2 answers
We have meetings at the beginning with the technical team to explain our requirements to them and they were really putting in a lot of effort to come up with a solution which will address all our needs. They implemented the software and also trained a few of our resources on the same too. We can get in touch with them now as well whenever we run into a roadblock but it's very less now.
Rahul Malik | TrustRadius Reviewer

Alternatives Considered

DB2

DB2 is a similar product that is most respected. Oracle might be supported in a broader context, but DB2 is superior on every platform where the choice is there. Licensing is also a factor in which DB2 is much better, which might offset any cost differences. DB2 support is also much better at all tiers.
Anonymous | TrustRadius Reviewer

Teradata Vantage Advanced SQL Engine (Teradata Database)

Microsoft is definitely the easiest solution for beginners. We can start our journey as fast as with MS Windows. We should only take care with the installation process to avoid mistakes, that will be hard to correct later. Oracle is a huge solution with many additional tools and middle-ware platform. Both MS and Oracle have much bigger internet support resources and communities; that is a huge advantage.
Mateusz Michałek | TrustRadius Reviewer

Scalability

DB2

DB2 9.7
Based on 10 answers
It can grow as your company grows. It also plays well with Crystal Reports and other BI software once you create an ODBC connection for the DB. It can be managed with SQL management studio so no extra software is needed for that.
Josh Rice, MBA, ACSP | TrustRadius Reviewer

Teradata Vantage Advanced SQL Engine (Teradata Database)

No score
No answers yet
No answers on this topic

Return on Investment

DB2

  • Positive - Very good performance as compared to other traditional DBs.
  • Positive - Transaction and query search are made easy from a DB level with good performance, also runs on top scape on AIX servers.
  • Negative - There is always room for improvement, such as Webex queries and the GUI base tool. Also the available support documentation should be improved.
Pradeep Bele | TrustRadius Reviewer

Teradata Vantage Advanced SQL Engine (Teradata Database)

  • Negative impact is again the slowness that would be felt by developers and users.
  • Negative impact is that there is a learning curve if they have been using any other type of SQL.
  • Positive impact is that you can collaborate with other developers by using projects.
Brian Dandeneau | TrustRadius Reviewer

Pricing Details

DB2

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Teradata Vantage Advanced SQL Engine (Teradata Database)

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Add comparison