DB2 10.5 for LUW Advanced Database Administration with DB2 BLU Acceleration
Corso
A Milano
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
Descrizione
-
Tipologia
Corso
-
Luogo
Milano
-
Inizio
Scegli data
Prerequisiti
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.
Target del corso
This is an advanced course for DB2 LUW experienced database administrators who support DB2 for UNIX, Windows, and Linux databases.
Sedi e date
Luogo
Inizio del corso
Inizio del corso
Opinioni
Materie
- Clustering
- Management
- Windows
- Unix
- Linux
Programma
Advanced Monitoring
Advanced Table Space Management
DB2 10.5 BLU Acceleration Concepts
DB2 10.5 BLU Acceleration Implementation and Use
Using Optimizer Profiles to control Access Plans
Table Partitioning
Advanced Data Movement
Advanced Table Reorganization
Multiple Dimension Clustering
DB2 Database Auditing
Agenda
Day 1
(00:20) Welcome
(02:00) Unit 1: Advanced Monitoring
(01:00) Exercise 1: DB2 Advanced Monitoring with SQL
(02:00) Unit 2: Advanced Table Space Management
(01:00) Exercise 2: DB2 Advanced DMS Table Space Management
Day 2
(02:00) Unit 3: DB2 10.5 BLU Acceleration Concepts
(01:45) Unit 4: DB2 10.5 BLU Acceleration Implementation and Use
(01:00) Exercise 3:Using DB2 BLU Acceleration to improve performance for analytics query processing.
Day 3
(02:30) Unit 5: Using Optimizer Profiles to control Access Plans
(01:00) Exercise 4: Using Optimizer Profiles to control Access Plans
(02:30) Unit 6: Table Partitioning
(01:30) Exercise 5: Range-partitioned Tables
Day 4
(02:30) Unit 7: Advanced Table Reorganization
(01:15) Exercise 6: Advanced Table Reorganization
(02:00) Unit 8: Multiple Dimension Clustering
(01:00) Exercise 7: DB2 Multidimensional Clustering
Day 5
(02:30) Unit 9: Advanced Data Movement
(01:15) Exercise 8: DB2 Advanced Data Movement
(01:00) Unit 10: DB2 Database Auditing
(01:00) Exercise 9: DB2 Database Audit implementation
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
DB2 10.5 for LUW Advanced Database Administration with DB2 BLU Acceleration