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
The DB2 BLU Engine, which introduced column-organized tables, was released with DB2 10.5 and greatly enhanced in 10.5 Fixpack 4. DB2 11.1 introduces BLU MPP – support for BLU tables within a DPF environment. This greatly increases the scalability of a BLU system.
DB2 has several new Cloud offerings. With DB2, you can get support for OLTP or Analytics. The database can be hosted or fully managed. This presentation by Kelly Schlamb at the 2015 IDUG Tech Conference in Australia details the three products, their differences and the use cases for each.