Db2 LUW performance tuning and monitoring (CL413G)

• DBAs who have inherited a slow database and do not know where to start.
• Teams about to review an application SQL before a performance audit.
• Anyone responsible for a database that grew more than planned.

• Database monitoring
• Database I/O management
• Table space and table design for performance
• Db2 memory management
• Automated memory management
• Performance seen from the application
• The explain tools
• The Db2 optimizer: how it decides
• Using indexes for performance
• Complex SQL performance
• Performance tools and utilities
• Event monitors

• Day 1: monitoring and I/O management
• Day 2: table space and table design, and memory management
• Day 3: performance from the application, explain and the optimizer
• Day 4: indexes, complex SQL, utilities and event monitors

• Labs on your own Db2 LUW release, on Linux, AIX or Windows depending on what you run.
• Taught directly by IBM Champion instructors from the SIXE team.
• Credly badges available: credly.com/organizations/sixe/badges
• Flexible format — online, classroom or onsite — in closed groups, priced per attendee, in the language of your choice (ES / EN / FR).

Does it apply if our database is partitioned?
This one covers the single-partition case. For multi-partition databases the course is CL443G, which adds a day for that scenario.

Do we work on a real case?
We work on the official labs. Send us one of your own access plans before the course and we will look at it in class.

How is it organised and what does it cost?
It runs as a closed group, priced per attendee. Tell us how many you are, which release you run and which dates suit you, and we will send a proposal.

• CL443G — Performance for single and multiple partition databases (five days, partitioning included)
• CL464G — Advanced Db2 administration (advanced monitoring and memory)
• CL207G — Db2 12.1 administration workshop (the groundwork, if it is not there yet)