IBM Db2 with BLU Acceleration is commonly used in warehouse environments to facilitate industry-leading analytical processing of data. This technology is composed of many valuable pieces, but two that we regularly highlight are extreme compression and advanced query performance.
Here is Keri Romanufa with a presentation covering the architecture of Db2, including what is new with Db2 11.5
DB2 is particularly good at running complex query and analytical processing. Since all modern hardware contains multiple cores and CPUs, and many systems are composed of multiple machines, it is critical that DB2 run individual queries across all available computing resources.
DB2 11 for LUW includes a broad set of enhancements to BLU Acceleration, taking the columnar in-memory database technology to a new level of maturity, performance, and scalability. Matthias Nicola from IBM provides an overview of new features and improvements in BLU Acceleration in DB2 11.1
By now, most DB2 for LUW users have probably heard about the release of DB2 11.1 that became available in June of this year. In this article I’d like to provide more information on some performance optimizations in DB2 11.1 that will benefit queries accessing both row and column-organized tables.