DB2 10.5 for LUW with BLU Acceleration and New Features

Thursday, 29 May, 2014 - 09:00 - 16:00
LUW Track
Melanie Stopfer

This one-day class is designed to describe the major technical features and enhancements provided by DB2 for Linux, UNIX and Windows database 10.5 software. A key feature of DB2 LUW 10.5 is new support for column-organized tables to provide accelerated analytic processing called BLU Acceleration. Additional new features in DB2 LUW 10.5 will also be covered.
After completing this class, you should be able to:
• Implement column-organized table support for a new or existing DB2 database
• Describe how the column dictionaries used to provide extreme compression of column-organized tables are built and utilized
• Explain the impact of setting the DB2 registry variable DB2_WORKLOAD to ANALYTICS
• List the seven ‘big ideas’ that work together to provide DB2 BLU acceleration
• Describe the different storage used for column-organized table compared to row-organized tables
• Explain how DB2 uses a synopsis table to support data skipping with column-organized tables
• Monitor a DB2 database or application that uses column-organized tables
• Use db2convert or ADMIN_MOVE_TABLE to convert row-organized tables to column-organized tables
• Explain the support for large row sizes with DB2 10.5
• Use DB2 Version 10.5 create an index that contains an expression-based key
• Monitor DB2 10.5 databases and instances using SQL table functions MON_GET_DATABASE and MON_GET_INSTANCE
• Recovery enhancements will also be discussed.



SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us



Events in 2020

VIRTUAL EVENT - 25th - 27th November 2020