Implementation and Use of DB2 BLU Acceleration (CL450G)

Course Description Schedule Course Outline

Who should attend

This is an intermediate course for DB2 LUW experienced database administrators who support DB2 for UNIX, Windows, and Linux databases and want to learn more about the DB2 BLU acceleration capabilities in DB2 10.5.


You should have completed:

  • DB2 10 for LUW: Basic Administration for Linux and Windows (CL2X3) or
  • DB2 10 for LUW: Basic Administration for AIX (CL213) or
  • DB2 10.1 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs (CL484)
  • Or have equivalent experience

Course Content

This course is designed to teach you how to:

  • Implement DB2 BLU Acceleration, column-organized table support, for a new or existing DB2 database.
  • Describe how the column dictionaries used for DB2 BLU Acceleration are built and utilized to provide extreme compression for column-organized tables.
  • Explain the default workload management used for DB2 BLU Acceleration processing and how you can tailor the WLM objects to efficiently use system resources.
  • Monitor a DB2 database or application that uses column-organized tables using SQL monitor functions.

You get practical experience in the planning and utilization of the DB2 BLU Acceleration functions, using DB2 LUW commands, utilities and SQL statements performing a lab exercise using DB2 Advanced Enterprise Edition 10.5 installed on a Linux platform.

Classroom Training

Duration 1 day

Price (excl. tax)
  • Germany: 790.- €
incl. catering
Catering includes:

  • Coffee, Tea, Juice, Water, Soft drinks
  • Pastry and Sweets
  • Bread
  • Fresh fruits
  • Lunch in a nearby restaurant

* Catering information only valid for courses delivered by Fast Lane.

Digital courseware Dates and Booking
Click on town name to bookSchedule
This is a FLEX course, which is delivered both virtually and in the classroom.
30/01/2017 Berlin
24/03/2017 Frankfurt
17/07/2017 Hamburg
08/09/2017 Munich
10/11/2017 Düsseldorf
FLEX Training

Please see below our alternative, English language, FLEX course options.

25/11/2016 FLEX training This is an English language FLEX course.
Time zone: Europe/Budapest
08/09/2017 Vienna (iTLS)

Fast Lane Flex™ Classroom If you can't find a suitable date, don't forget to check our world-wide FLEX™ training schedule.