IBM DB2 LUW course Performance tuning and monitoring for single and multiple partition databases

Course data

• IBM code: CL443GES / CL443G
• Category / Subcategory: DB2 / DB2 TUNING
• Modality: Online and face-to-face
• Duration in days: 5

Target audience

This is an advanced course for database designers, database administrators and application developers working with DB2 for Linux, UNIX and Windows who are concerned about performance on single and multi-partition databases. The course is updated to work with the latest versions of DB2, including DB2 11.5 and new optimization features.

Desired prerequisites

Must complete:

• DB2 for LUW Multi-partition DBA Workshop (CL240) o
• DB2 for LUW Multi-partition environment for single-partition DBA (CL250)

Instructors

The vast majority of IBM courses we offer are taught directly by our certified engineers. This is the only way to guarantee the highest quality. We complement all training with our own materials and laboratories, based on our experience during the deployments, migrations and courses we have conducted over the years.

Value added

Our courses are deeply oriented to the role to play. It is not the same the needs of mastering a technology for a team of developers, as it is for the people in charge of deploying and managing the infrastructure. That’s why, beyond commands and tasks, we focus on solving the problems that arise in the day-to-day of each team. Providing them with the knowledge, skills and skills required for each project. In addition, our documentation is based on the latest version of each product, including the performance improvements introduced in DB2 12.1.

Course agenda and syllabus

• Database monitoring – Advanced monitoring techniques and analysis of performance metrics
• Database I/O management – Input and output system optimization for maximum throughput
• Designing tablespaces and tables for performance – Performance oriented design strategies.
• DB2 Memory Management – Configuring and optimizing memory for different workloads
• Automated memory management – Implementation of automatic memory management and best practices
• Application Performance Considerations – Optimization from the Application Side
• Use of explain tools – In-depth analysis of execution plans
• The DB2 optimizer – Understanding and configuring the optimization engine
• Use of indexes for performance – Advanced indexing strategies
• Complex SQL Performance – Optimization of complex queries and procedures
• Performance tools and utilities – Complete suite of analysis tools
• Event monitoring – Real-time monitoring implementation and analysis
• Performance Tuning Considerations in Partitioned Databases – Specific Optimization for Distributed Environments
• Row relocation strategies and performance considerations FCM – Advanced data distribution techniques

Learning objectives

At the end of this course, participants will be able to:

• Adjust parameters to achieve optimal performance for OLTP or Data Warehouse environments
• Identify and use tools that assist in the monitoring and tuning of single and multi-partition databases
• Analyze explain reports to identify performance bottlenecks
• Implement specific optimization strategies for each workload type
• Configure and manage memory efficiently in different scenarios
• Applying best design practices to maximize performance

Locations for face-to-face training