Implementation and Use of DB2 BLU Acceleration Eğitimi

Ön Kayıt ve Fiyat Bilgi Formu



Tarih ve lokasyonlar


Bu eğitimi özel sınıf olarak kendi kurumunuzda talep edebilirsiniz.
Lütfen bizimle iletişime geçin:


info@bilginc.com

+90 212 282 7700

Talep Formu
Eğitim Tipi ve Süresi

1 Day ILT    

Implementation and Use of DB2 BLU Acceleration (1L450G)

IBM Course Code: 1L450G

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, and by performing a lab exercise using DB2 Advanced Enterprise Edition 10.5 installed on a Linux platform.

What You'll Learn

  • Implement DB2 BLU Acceleration, column-organized table support, for a new or existing DB2 database
  • Configure a DB2 database that uses DB2 BLU Acceleration, column-organized tables, including sort memory and utility heap memory considerations
  • Describe the default workload management used for DB2 BLU Acceleration processing and how you can tailor the WLM objects to efficiently use system resources
  • Locate the column-organized processing portion of the access plans for column-organized tables in DB2 explain reports
  • Use db2convert or ADMIN_MOVE_TABLE to convert row-organized tables to column-organized tables

Who Needs to 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.

Prerequisites

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

Follow-On Courses

There are no follow-ons for this course.

Course Outline

  • DB2 10.5 BLU Acceleration Concepts
  • DB2 10.5 BLU Acceleration Implementation and Use



Eğitim içeriğini PDF olarak indir

Eğitim Sağlayıcı ve Kategori

IBM  » DB2 Eğitimler
IBM  » Database Management & Development Eğitimler
Database Management & Development  » Database Management & Development Eğitimler