Bases de données relationnelles - Décisionnel / DB2

Formation: Implémentation et Utilisation de DB2 BLU Acceleration ( 1 Jour )

Consulter les villes disponibles, le calendrier et nos tarifs dégressifs pour cette formation

Durée

1 Jour(s)

Pré-requis

Objectifs

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

Programme

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

 

Objectifs

  • 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

Contenu

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

Agenda

Day 1

  • (02:00) Unit 1: DB2 10.5 BLU Acceleration Concepts
  • (02:00) Unit 2: DB2 10.5 BLU Acceleration Implementation and Use
  • (01:00) Exercise 1:Using DB2 BLU Acceleration to improve performance for analytics query processing.

 

 

 

 
  
 
Certificat/Attestation
Délivrance d'une attestation de fin de formation
 
Modalités d’évaluation
A l'issue de la formation, un certificat de formation sera délivré au stagiaire
 
Modalités de l'examen
 
contactez-vous decouvrez nos formation en region decouvrez nos formation en region devis

Mots-Clés