DB2 for Linux, UNIX and Windows

Accelerate insight. Improve resiliency. Maintain flexibility.

Primary tab navigation

DB2 with BLU Acceleration

IBM DB2 with BLU Acceleration speeds analytics and reporting using dynamic in-memory columnar technologies. In-memory columnar technologies provide an extremely efficient way to scan and find relevant data. Coupled with innovations such as parallel vector processing and actionable compression, it makes your analytic queries far faster and less complex. So you can connect with the information you need at breakthrough speed and volume.

Analytics at the speed of thought

DB2 with BLU Acceleration combines advanced, innovative capabilities to accelerate analytic workloads for databases and data warehouses.

DB2 with BLU Acceleration also integrates with IBM Cognos® Business Intelligence to provide reporting and deeper analysis. You can analyze key facts and freely explore information from multiple angles and perspectives to make more informed decisions—all from within DB2.

Less data storage required

DB2 with BLU Acceleration dynamically moves data from storage. Database tuning, indexes and aggregates are not needed, which improves storage efficiency and helps lower your storage space requirement. In fact, clients have reported compression rates of 10 times that of un-compressed tables.i

The system uses available hardware such as memory, I/O and CPU to help reduce memory latency and processing. Hardware optimization streamlines administration and maintenance, putting less load on resources.


BLU Acceleration is fully integrated with DB2. It does not require SQL or schema changes to implement. Just load and go. Enhancements such as automation, optimization and self-tuning help to further simplify overall use.

When we compared the performance of column-organized tables in DB2 to our traditional row-organized tables, we found that, on average, our analytic queries were running 74x faster when using BLU Acceleration.

- Kent Collins, Database Solutions Architect, BNSF Railway

Speed, simplicity and affordability

Speed, simplicity and affordability

Three must-have capabilities for today's warehouse environment

Two ways to test drive DB2 with BLU Acceleration

Two ways to test drive DB2 with BLU Acceleration

See BLU Acceleration in-memory computing in action on the cloud or download free trial software.

Get Started

Get Started

IBM offers a range of online learning, technical workshops and services to help you leverage DB2 with BLU Acceleration for in-memory computing.

Get Social

Get Social

BLU Acceleration discussions through blogs, videos, podcasts and more!

DB2 with BLU Acceleration Resources


Download and use DB2 for 90 days

Download and use DB2 for 90 days.

Use DB2 core database functions, warehousing capabilities and other advanced features for up to 90 days

Find solutions, industry reports, white papers, videos and more

DB2 Library

Find solutions, industry reports, white papers, videos and more