Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

DB2 10.5 for LUW New Features and Database Upgrade Considerations

IBM Course Code: CL314CE

Vendor# CL314G

GK# 9649

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.

Delivery Format Options

  • Classroom Live

    Classroom Live

    Receive face-to-face instruction at one of our training center locations.

    From

    $795 CAD

    1 day

  • Virtual Classroom Live

    Virtual Classroom Live

    Experience expert-led online training from the convenience of your home, office or anywhere with an Internet connection.

    From

    $895 CAD

    1 day

  • Self-Paced

    Self-Paced

    Recordings, hands-on labs and expert instructors empower you to train on your own schedule.

    From

    $256 CAD

    1 session

  • Private Group Training

    Private Group Training

    Train your entire team in a private, coordinated professional development session at the location of your choice.

    Receive private training for teams online and in-person.

Request a date or location for this course.

What You'll Learn

  • 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

Who Needs To Attend

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.