Opleiding: IBM Db2 12.1: Performance and Tuning Optimization for Relational DBAs [TDS_CLA94G]
OVERVIEW
This course equips experienced database administrators with the skills needed to analyze, tune, and optimize the performance of IBM Db2 12 for Linux, UNIX, and Windows.
Participants will learn how to interpret and influence the Db2 query optimization process using statistical metadata, develop efficient indexing strategies for high-performance workloads, and apply advanced tools such as EXPLAIN, db2pd, and the Db2 Data Management Console to evaluate and refine SQL access paths.
The course also introduces the Db2 AI Optimizer and automation techniques that simplify statistics collection and performance diagnostics. Emphasis is placed on real-world use cases, practical monitoring methods, and proactive tuning practices to ensure scalable and efficient database operations in enterprise environments.
Virtueel en Klassikaal™
Virtueel en Klassikaal™ is een eenvoudig leerconcept en biedt een flexibele oplossing voor het volgen van een klassikale training. Met Virtueel en Klassikaal™ kunt u zelf beslissen of u een klassikale training virtueel (vanuit huis of kantoor )of fysiek op locatie wilt volgen. De keuze is aan u! Cursisten die virtueel deelnemen aan de training ontvangen voor aanvang van de training alle benodigde informatie om de training te kunnen volgen.
OBJECTIVES
After completing this course, learners should be able to:
- Configure and manage statistics profiles to guide and automate statistics collection procedures
- Evalue the impact of the Db2 AI Optimizer on query plan generation and performance recommendations
- Design and implement optimal indexes for performance based on workload analysis and query structure
- Utilize the Db2 Design Advisor to obtain and implement index recommendations for performance gains
- Capture and interpret EXPLAIN data using tools such as db2exfmt, db2expln, and Activity Event Monitor
- Use SQL-based table functions and administrative views to retrieve real-time and historical monitoring data
- Leverage the Db2 Data Management Console to visualize resource usage and performance indicators
AUDIENCE
This advanced course targets experienced database administrators.CONTENT
Unit 1: Statistics and Query Optimization
Unit 2: Indexing for Performance Improvements
Unit 3: Using EXPLAIN Tools for Query Optimization
Unit 4: Monitoring Fundamentals
