Seminar - Cegos Integrata GmbH
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.
Termin | Ort | Preis* |
---|---|---|
firmenintern | auf Anfrage | auf Anfrage |
Course Outline
Unit 1: Statistics and Query Optimization
Unit 2: Indexing for Performance Improvements
Unit 3: Using EXPLAIN Tools for Query Optimization
Unit 4: Monitoring Fundamentals
Objective
After completing this course, learners should be able to:
Prerequisites
Prior to enrolling in this course, participants should have:
Audience
TBD