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.
IDUG Content Committee member describes improvements in BLU performance in DB2 for LUW V11.1