IBM Db2 12.1: Performance and Tuning Optimization for Relational DBAs

Course 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.

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.

Who should attend

TBD

Prerequisites

Prior to enrolling in this course, participants should have: • Completed CLA90G, CLA91G, and CLA93G or have equivalent experience • A working knowledge of Db2 database administration • A basic understanding of SQL and query design • Familiarity with Db2 system catalogs • Exposure to Db2 utilities and monitoring commands

Delivery formats

• • Instructor-led online (virtual classroom)
• • Instructor-led on-site at your premises
• • Self-paced online training
• • Private/closed group delivery for corporate teams

Digital badge

Delegates completing this course are eligible for an IBM digital badge, issued via Credly. View the badge

Related and follow-on courses

• 2LA92G — IBM Db2 12.1: Advanced Data Management and Recovery for Relational DBAs (Advanced)
• B6359G — IBM Cognos Analytics: Author Reports Advanced (v11.2) (Advanced)
• 0A069G — IBM SPSS Modeler Foundations (V18.2) (Basic)
• 0A079G — Introduction to Machine Learning Models Using IBM SPSS Modeler (V18.2) (Basic)