Каталог курсов

Курсы IBM

DB2 10.5 for LUW New Features and Database Upgrade Considerations

 
Код курса  Код: CL314    Заявка  Предварительная запись    Продолжительность  Кол-во часов: 8 , Кол-во дней: 1

IBM.gif

Подробное описание курса.

 

Description


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.

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

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.

PreRequisites


You should have:
  • Experience supporting DB2 Linux, UNIX and Windows Version 9.7, 9.8 or 10.1 databases

Topics


1. 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

Related


You may also be interested in the following courses
This course provides students an in-depth understanding of the concepts and appropriate use of data
stored in IBM’s relational database ...

DB2 SQL DBDB-340P

This course teaches you to perform, basic database administrative tasks using DB2 10.1 for Linux, UNIX,
and Windows. These tasks ...

DB2 10 Administration Workshop for Linux and Windows - WBT 1L2X3GWUA

Дополнительную информацию по учебным программам IBM в Украине вы можете получить на сайте: www.ibm.com/training/ua (Учебный центр в Украине).

 


Место проведения мероприятия: г. Киев пр., В. Лобановского, 4г DB2 10.5 for LUW New Features and Database Upgrade Considerations +380444922929
Время проведения: Уточняйте
Ссылка курса обучения
Назад в раздел





Для предварительной записи на курсы или
уточнения информации позвоните по телефонам:
(044) 492-29-29, 594-98-98
e-mail: training@muk.com.ua

Или заполните заявку online.

Свежие новости

19.06.2017 Авторизованные курсы Microsoft на базе Учебного центра МУК


Учебный центр МУК - Silver Learning Partner Microsoft - приглашает всех желающих стать участником авторизованных курсов Microsoft согласно ближайшего расписания. 

01.06.2017 Открыт набор на курс «Виртуализация серверов с Windows Server Hyper-V и System Center»
Учебный центр МУК обладая статусом Silver Learning Partner Microsoft объявляет набор на курс «Виртуализация серверов с Windows Server Hyper-V и System Center», который состоится с 06 по 09 июня 2017 года.

21.05.2017 Снова лучшие: Dell EMC награждает МУК
Группа компаний МУК получила две награды на Dell EMC Partner Awards 2017

17.05.2017 HPE Education Brunch 2017
Учебный центр Группы компаний MUK при поддержке НРE Украина уже традиционно приглашает желающих стать участниками HPE Education Brunch 2017