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

Курсы IBM

DB2 10.1 for LUW New Features and Database Migration Considerations

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


IBM.gif

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


Description


Get the technical information about the new functions and features available in DB2 10.1 for Linux, UNIX, and
Windows and plan the migration for DB2 Version 9.5, 9.7 or 9.8 database systems to DB2 LUW 10.1.
DB2 Version 10.1 for Linux, UNIX, and Windows continues to deliver database efficiency, simplicity, and
reliability. Important new features and enhancements address the needs of your business. Whether your
needs are improving business critical reliability and performance, simplifying consolidation and security,
increasing business insight, reducing costs, or providing a resilient system for the valuable information assets
of your company, DB2 Version 10.1 delivers.

The course will describe the adaptive compression feature of DB2 LUW 10.1 that improves table
compression through an advanced row compression technique that uses two levels of compression
dictionaries (table-level and page-level) to improve compression ratios, particularly as data changes.
DB2 LUW 10.1 support for Multi-temperature storage allows administrators to define storage groups that can
be used to assign data based on performance characteristics and migrate data to a storage group with lower
cost devices or lower performance when the demand for that data declines.

The lectures will describe the DB2 LUW 10.1 performance related features including improved query
optimizer techniques and functionality including star schema query optimization, improved data and index
prefetching, and improved use of statistical views.

We will discuss how to implement system period and application period temporal tables associated with Time
Travel Query to assign time-based state information to your data, so you can query the past state of your
data.

DB2 LUW 10.1 introduces row and column access control (RCAC), as an additional layer of data security.
Row and column access control is sometimes referred to as fine-grained access control or FGAC. We will
discuss using RCAC to control access to a table at the row level, column level, or both and how RCAC can
be used to complement the table privileges model.

The database high availability feature HADR is significantly enhanced with DB2 LUW 10.1. We will discuss
how with DB2 10.1 you can define up to three standby databases. The lecture will also explain how to
implement one standby database with the new time-delayed replay feature, which helps to recover from
application errors that cause data loss on the primary.

We will cover various migration planning and installation considerations to help move existing DB2 LUW
databases to DB2 LUW 10.1 to take advantage of the new features and functions.

Objectives


Please refer to Course Description.

Audience

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

PreRequisites

You should have:

  • Experience supporting DB2 LUW Version 9.5, 9.7 or 9.8 databases.

Topics

  • Please refer to Course Overview.

Related


You may also be interested in the following courses
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
Get the technical information about the new functions and features available in DB2 10.1 for Linux, UNIX,and Windows and ...

DB2 10.1 for LUW New Features and Database Migration Considerations (WBT) 1L313UA

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

 


Ссылка курса обучения
Назад в раздел





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

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

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

13.11.2017 Бесплатные практические вебинары MICROSOFT
Приглашение на бесплатные практические вебинары "Portal and billing MUK CSP" и "Trials and reseller’s Storefront" для партеров на базе Учебного центра МУК

06.11.2017 Со скидкой 20,18% на все курсы IBM с Учебным центром МУК в 2018 год

Планируйте курсы IBM на 2018 год вместе с нами до 31 декабря 2017 и получайте скидку 20,18%.

31.10.2017 HPE Education Brunch in Tbilisi 2017 собрал партнеров и заказчиков со всей Грузии

19 октября 2017 года прошло масштабное мероприятие - HPE Education Brunch in Tbilisi 2017 - организованное Учебным центром МУК Грузия совместно с Hewlett Packard Enterprise.

11.10.2017 Мобильный тестовый центр Pearson VUE в Учебном центре МУК
С октября 2017 на базе Учебного центра МУК начал свою работу Мобильный тестовый центр Pearson VUE