IBM Db2 Big SQL

A hybrid SQL-on-Hadoop engine delivering advanced, security-rich data query across enterprise big data sources, including Hadoop, object storage and data warehouses

Try the free edition
Person studying information on laptop

Overview

IBM Db2 Big SQL is an enterprise-grade, hybrid ANSI-compliant SQL-on-Hadoop engine, delivering massively parallel processing (MPP) and advanced data query. Db2 Big SQL offers a single database connection or query for disparate sources such as Hadoop HDFS and WebHDFS, RDMS, NoSQL databases, and object stores. Benefit from low latency, high performance, data security, SQL compatibility, and federation capabilities to do ad hoc and complex queries.

 IBM Db2 Big SQL now available on IBM Cloud Pak® for Data Try watsonx.data
Quickly query across platforms

Access and analyze data and perform queries on batch and real-time data across sources, like Hadoop, object stores and data warehouses.
Flexibly scale

Based on your requirements, shift workloads within public and private cloud and on-premises environments to achieve the hybrid cloud flexibility you need.
Drive real-time analytics

Concurrently exploit Hadoop SQL queries across Hive, Hbase and Spark, using a single database connection — even a single query — to achieve analytics in real time.
Connect your data

Make data available to data scientists and analysts with connections to IBM Watson® Studio and existing Jupyter Notebooks to federate to RDBMS and to Oracle, Db2 and IBM Netezza®.
Improve performance

Numerous users can query at the same time, with the ability to run all 99 TPC-DS queries up to 100 TB, supporting multiple workers per node for efficient utilization.

Use cases

Better data-driven decisions

Integrate new forms of semi and unstructured data (social media, sentiment, streaming audio/video, log and more) with your traditional structured data using advanced querying capabilities.

 Data warehouse modernization

Free up bandwidth and storage. Cloudera Enterprise Data Hub and Db2 Big SQL provide a superior platform for offloading historical or cold data in Oracle data marts and warehouses to Hadoop.

 Real-time data queries

Equip your data users with the right tools including Db2 Big SQL integrated with Apache Spark so they can do ad hoc and real-time queries to meet the needs of the business.

 Operational improvements

Use virtualization and federation to unify data access across the logical enterprise data warehouse, cloud and Hadoop for more accurate data-driven decisions.

Product images

Product charts showing Db2 Big SQL service landing page
Complex querying

Db2 Big SQL’s robust engine executes complex queries for relational data and Hadoop data, making querying enterprise data from across the organization an easy and secure experience.
Product charts showing Db2 Big SQL metrics dashboard
Monitoring capabilities

Monitor service metrics with intuitive dashboards help to identify the root causes of slowdowns, helping to maximize resources and performance.
Product chart showing creative service instance and pods
Simplified deployment 

Db2 Big SQL has a simplified deployment experience, helping to easily create service instances and allocate resources.
Product charts and graphs showing instance configurator
Dynamic scaling 

Based on workload needs, scale the instance up or down by allocating additional or fewer resources.
Product charts showing Db2 Big SQL service landing page
Complex querying

Db2 Big SQL’s robust engine executes complex queries for relational data and Hadoop data, making querying enterprise data from across the organization an easy and secure experience.
Product charts showing Db2 Big SQL metrics dashboard
Monitoring capabilities

Monitor service metrics with intuitive dashboards help to identify the root causes of slowdowns, helping to maximize resources and performance.
Product chart showing creative service instance and pods
Simplified deployment 

Db2 Big SQL has a simplified deployment experience, helping to easily create service instances and allocate resources.
Product charts and graphs showing instance configurator
Dynamic scaling 

Based on workload needs, scale the instance up or down by allocating additional or fewer resources.

Read from our technical experts

Read from IBM subject matter experts, learn from the experiences of fellow Db2 users, and take the opportunity to share your own best practices.
IBM Power10 E1080 Rack
IBM’s Power PCR for Db2 Warehouse Solution – Chapter 4: Enabling Q Replication

Learn how Q Replication on IBM’s Power PCR ensures high availability and disaster recovery through real-time data synchronization
A graphic illustration of a building with people and data cubes, representing data analysis.
Db2 AI Query Optimizer: Expanded Predicate Support and Improved Model Training

Explore the latest advancements in AI-powered query optimization, including smarter selectivity estimation and faster model deployment.
woman working on tablet around secure data
Optimize NVMe Drive Utilization for NCOS/System Temporary Tablespaces using OpenEBS LVM

Discover best practices for deploying Db2 Warehouse on AWS EKS with optimized NVMe storage for multi-tiered architectures.
Woman holding tablet surrounded by documents, analytics and search.
Vector Indexes in Db2 – An early preview

Find out how Db2’s new vector indexing accelerates similarity search for AI workloads with up to 3X performance gains.
A 3D rendering of a blue and white structure with a square base and a pyramid-shaped top.
Db2 Iceberg - Chapter 2: Time Travel Queries

Discover how Db2 Iceberg enables time travel queries for historical data access and snapshot-based rollback.
Three tall, black, rectangular objects with a blue glow against a blue background.
Introducing IBM’s Power Private Cloud Rack for Db2 on Red Hat Enterprise Linux

Explore how IBM’s Power Private Cloud Rack for Db2 on RHEL delivers scalable, high-performance database infrastructure.
A graphic of a person viewing data on a screen, connected to a database.
Db2 v12.1.1.0: Making Reorg Rebuild Better for Your Business

Learn how online index rebuilds in pureScale minimize downtime and improve performance for mission-critical databases.
Illustration of a blue shield and key, surrounded by people working on computers.
UCA Collations in Db2 12.1: Usage and Recommendations

Explore best practices for maintaining compatibility and performance in UCA-collated Db2 environments.
Take the next step

Get started with IBM Db2 Big SQL.

 Try the free edition
More ways to explore Documentation Support FAQ Community Data and Analytics Consulting Services