DB2 10.5 for Linux, Unix and Windows features exciting and ground breaking data management innovation for analytic processing. BLU Acceleration is new technology for analytic queries in DB2 LUW.
Join us for our latest podcast series with DB2 expert Iqbal Goralwalla and IBM DB2 Program Director George Baklarz as they take us through the 7 Big Ideas for DB2 10.5.
Listen and Download the Latest Podcast
Big Idea 4: Core-Friendly Parallelism
In DB2 10.5 with BLU Acceleration, very close attention has been given to multi-core parallelism due to the realization that the number of CPU cores on a single server continues to increase. DB2 with BLU Acceleration is designed from the ground up to take advantage of the cores on your server and to always drive multi-core parallelism for the queries you have. Access plans on column organized tables will leverage all of the cores on the server simultaneously to deliver better analytic query performance. This is all done in shared memory. Central to this idea is to change the inflection point where you need to leverage MPP technologies so that smaller warehouses and marts that contain raw data around 10TB can fit into a single system. This results in lower costs and makes it easier to manage data marts on a single server instead of the overhead of managing a cluster or logical partitions ( continuing the simplicity theme of Idea 1).
In DB2 10.5 with BLU Acceleration, memory latency and memory access have been carefully analyzed. For BLU Acceleration, main memory access is too slow. It is something to be avoided. BLU Acceleration is designed to access data on disk very rarely, access RAM only occasionally, and do the overwhelming bulk of its processing from data and instructions that reside in a CPU cache.