CL463G DB2 10.5 for LUW Advanced Database Administration with DB2 BLU Acceleration

Il centro presenta a continuazione il programma pensato per migliorare le tue competenze e permetterti di realizzare gli obiettivi stabiliti. Nel corso della formazione si alterneranno differenti moduli che ti permetteranno di acquisire le conoscenze sulle differenti tematiche proposte. Inscriviti per poter accedere alle seguenti materie.

• 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

• (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

• (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.

• (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

• (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

• (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

Dotazione:
Each participant will have a station set up with operating systems and software needed for the exercises.