Skip to main content
TrustRadius
Db2 Big SQL

Db2 Big SQL

Overview

What is Db2 Big SQL?

IBM offers Db2 Big SQL, an enterprise grade hybrid ANSI-compliant SQL on Hadoop engine, delivering massively parallel processing (MPP) and advanced data query. Big SQL offers a single database connection or query for disparate sources such as HDFS, RDMS, NoSQL…

Read more
Recent Reviews
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Return to navigation

Product Details

What is Db2 Big SQL?

Db2 Big SQL Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(17)

Attribute Ratings

Reviews

(1-2 of 2)
Companies can't remove reviews or game the system. Here's why
Gene Baker | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We were evaluating database platforms to replace a seven database instance of Sybase which was being used by our application. Our goal was to collapse the data and consolidate it into a single instance. IBM DB2 Big SQL was one of the platforms we did an extensive evaluation of. We were excited about this platform because it gave us the ability to have a single database connection to connect to multiple disparate data stores. Our goal was to simplify our environment, our application and improve our performance. This was just being evaluated by our department and was not in use elsewhere at the time we did the evaluation.
  • SQL compatibility.
  • High performance.
  • Cloud readiness.
  • Ease of implementation.
My recommendation obviously would depend on the application. But I think given the right requirements, IBM DB2 Big SQL is definitely a contender for a database platform. Especially when disparate data and multiple data stores are involved. I like the fact I can use the product to federate my data and make it look like it's all in one place. The engine is high performance and if you desire to use Hadoop, this could be your platform.
  • Performance gains were positive.
  • Finding resources on the street with knowledge at the time was hard.
MS SQL Server was ruled out given we didn't feel we could collapse environments. We thought of MS-SQL as more of a one for one replacement for Sybase ASE, i.e., server for server. SAP HANA was evaluated and given a big thumbs up but was rejected because the SQL would have to be rewritten at the time (now they have an accelerator so you don't have to). Also, there was a very low adoption rate within the enterprise. IBM DB2 Big SQL was not selected even though technically it achieved high scores, because we could not find readily available talent and low adoption rate within the enterprise (basically no adoption at the time). We ended up selecting Exadata because of the high adoption rate within the enterprise even though technically HANA and Big SQL were superior in our evaluations.

MongoDB Atlas, Atlassian JIRA Align (formerly AgileCraft), Atlassian Confluence
No
  • Price
  • Product Features
  • Product Usability
  • Vendor Reputation
  • Existing Relationship with the Vendor
  • Positive Sales Experience with the Vendor
We selected this product for our evaluation and proof of concept based on our existing relationship with the vendor and their positive reputation. We have experience using other products in our environment and have good things to report out those products. So it was natural for us to want to leverage another product from their offerings.
The only change I would make would be to have hired someone from their professional services to help us get to our answer and solution sooner. Otherwise, I don't think I would change anything about the way we approached this. We had 4 products that we evaluated and created a scorecard and test suite for the evaluation. IBM Big SQL DB2 scored high.
IBM did a good job of supporting us during our evaluation and proof of concept. They were able to provide all necessary guidance, answer questions, help us architect it, etc. We were pleased with the support provided by the vendor. I will caveat and say this support was all before the sale, however, we have a ton of IBM products and they provide the same high level of support for all of them. I didn't see this being any different. I give IBM support two thumbs up!
Yes
We have extended support with our vendor. Given the size of our book of business, it just makes sense to have the highest level of support available so in the unlikely event of an outage, we can restore service as soon as possible for our customers and business partners. Saving a few dollars on support but then losing it in lost business just doesn't seem prudent.
No
We had an issue connecting to one of our data sources. We called support and within 5 minutes had resolved the issue that had stumped us for several hours.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
IBM DB2 Big SQL is being used as a database to record fact table transactions in our downstream operations. It is being used by the IT department as a core database but focusing on legacy application support. It solves the problem of storing and retrieving mission critical data that is primarily relational.
  • data storage
  • data manipulation
  • data definitions
  • data reliability
  • complexity of database
  • interface and innovation
IBM Db2 is a legacy database and is primarily great for supporting certain legacy applications. It's simply not as competitive as many solutions on the market now.
  • better data visibility
  • solid reliability for mission critical data
IBM DB2 is a solid service but hasn't seen much innovation over the past decade. It gets the job done and supports our IT operations across digital so it is fair.
IBM is a well known company and supports the data and infrastructure they put out relatively well. I am a fan of their support as it is relatively extensive.
Return to navigation