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. While both...
Here is Keri Romanufa with a presentation covering the architecture of Db2, including what is new with Db2 11.5 https://youtu.be/Lkr0Er IhV4
DB2/LUW is a relational database the can be used for many types of applications, from operational systems running very high number of users and transaction to data marts and large data warehouses. DB2 is particularly good at running complex query and analytical processing on a variety of...
This month's IDUG Tech Talk video was recorded at the 2016 IDUG DB2 EMEA Tech Conference in Brussels, Belgium. DB2 11 for Linux, UNIX, and Windows includes a broad set of enhancements to BLU Acceleration, taking the columnar in-memory database technology to a new level of maturity, performance...
DB2 11.1 BLU Performance One of the best features of DB2 BLU is that columnar tables are not in a separate database from row organized tables. They are both processed by the same runtime and you can combine both row and columnar tables in the same query. However, the actual...
Scaling DB2 BLU Horizontally with DB2 11.1 By: Joe Geller & Ian Bjorhovde The DB2 BLU Engine, which introduced column-organized tables, was released with DB2 10.5 and greatly enhanced in 10.5 Fixpack 4. Even though the performance of analytical queries showed tremendous...
by Somu Chakrabarty and Iqbal Goralwalla, Triton Consulting IBM has introduced the concept of shadow tables in DB2 10.5 Fixpack 4 (also known as the “Cancun Release”) to avoid separate OLTP and OLAP databases and to improve analytic query performance in a single OLTP database without using...
1 Comment - no search term matches found in comments.
The BLU Acceleration Technology introduced in DB2 10.5 brings with it a host of new monitoring considerations and metrics. This session will introduce you to the new monitoring capabilities that support BLU Acceleration and through practical examples will show you how you can leverage these in...
One of the selling points of DB2 10.5 and the Columnar options is that existing row-based tables can be converted to column-based tables and will be accessed by DB2 seamlessly and with no extra effort from the DBA. All well and good, and the performance should be much better, but what if it’s...
Hi everyone. In the DB2 labs, we've been very busy over the past few months getting our Cancun release (aka 10.5 FP4) ready. Even though it's mechanically a fixpack, this level of DB2 contains some very exciting new capabilities. Please join me as I take you through them. You'll hear...