Skip to main Content

DB2 10.5 for LUW New Features and Database Upgrade Considerations

  • Course Code CL314G
  • Duration 1 day

Additional Payment Options

  • GTC 10

    GTC, Global Knowledge Training Credit, please contact Global Knowledge for more details

Public Classroom

Public Classroom Price


Request Group Training Add to Cart

Course Delivery

This course is available in the following formats:

  • Company Event

    Event at company

  • Public Classroom

    Traditional Classroom Learning

  • Virtual Learning

    Learning that is virtual

Request this course in a different delivery format.

Course Overview


This course is designed to describe the major technical features and enhancements provided by the DB2 for Linux, UNIX and Windows database 10.5 software.

DB2 10.5 has two primary areas of focus.

One key feature of DB2 10.5 is new support for column-organized tables to provide accelerated analytic processing called BLU Acceleration.

Another important focus are for DB2 10.5 is a set of enhancements for the DB2 pureScale feature, including online topology changes and the support for High Availability Disaster Recovery (HADR) with a DB2 pureScale cluster.

Course Schedule


Target Audience


This intermediate course is for system administrators, database administrators, and technical personnel involved in planning, implementing, and maintaining DB2 LUW 10.5 databases and have experience working with DB2 LUW Version 9 or Version 10.1 Prerequisites.

Course Objectives

  • 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
  • Describe the DB2 pureScale cluster topology changes that can be made online, without database downtime
  • Plan and implement High Availability Disaster Recovery (HADR) for a DB2 pureScale database
  • Explain how member subsets can be used to manage how an application views the topology of the pureScale database environment
  • Utilize DB2 provided routines to define, alter and drop member subsets for a pureScale database
  • Explain which types of Backup and Restore operations for DB2 pureScale databases can utilize online backups or require offline database backups.
  • Describe the product packaging enhancements in DB2 10.5 including the new Advanced Workgroup Server edition
  • Plan the upgrading of existing DB2 database servers to DB2 10.5
  • Explain the support for large row sizes with DB2 10.5
  • List the supported operating systems for running DB2 10.5 database servers
  • 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

Course Content


Day 1

  • (00:30) Welcome
  • (03:00) Unit 1 - DB2 10.5 BLU Acceleration using Column-organized Tables
  • (01:30) Unit 2 - DB2 10.5 enhancements for the DB2 pureScale feature
  • (01:00) Unit 3 - Planning for DB2 10.5 implementation, and Additional general usage features for DB2 database servers

Course Prerequisites


You should have:

  • Experience supporting DB2 Linux, UNIX and Windows Version 9.7, 9.8 or 10.1 databases