Tridex Db2 LUW – June 16th 2022 agenda

10:00 – 11:00Dale McInnis, IBM
Running Db2 PureScale in a Public Cloud
11:00 – 11:05Break
11:05 – 12:05David Kalmuk, IBM
The Latest in Advanced Performance Diagnostics for SQL
12:05 – 1:00Lunch Break
1:00 – 2:00John Hornibrook, IBM
How to Relieve the Db2 Optimizer of Its Duties

Desperate Measure – How to Relieve the Db2 Optimizer of Its Duties

Download PDF

Watch recording (logged in Tridex members only)

Session title: Desperate Measure – How to Relieve the Db2 Optimizer of Its Duties

Session abstract: Optimal query access plans are essential for good data server performance, and it is the query optimizer’s job to choose the best one. However, occasionally no amount of statistics or tuning is enough to get the access plan you want. Or your application is effectively down, due to a poorly performing query, and there isn’t time to implement best practices. When these situations arise, Db2 optimization profiles and guidelines can be used to correct the access plan and get your application performing well again, quickly. Optimization profiles can specify various aspects of an access plan, can control automatic query rewriting or can control the optimizer’s plan search space. Guidelines can be specified with or without modifying your application. This presentation will show you what options are available and how to use them effectively.

Speaker biography: John is a Senior Technical Staff Member responsible for relational database query optimization on IBM’s distributed platforms. This technology is part of Db2 for Linux, UNIX and Windows, Db2 Warehouse, Db2 on Cloud, IBM Integrated Analytics System (IIAS), IBM Db2 Analytics Accelerator (IDAA) and Db2 Big SQL. John also works closely with customers to help them fully realize the benefits of IBM’s relational DB technology products.

Tridex Db2 LUW – March 24th 2022 agenda

10:00 – 11:00Martin Hubel
The Data Pioneer: Recovery
11:00 – 11:15Break
11:15 – 12:15Ember Crooks
Db2 Basics: Monitoring and Troubleshooting Db2
12:15 – 1:00Lunch Break
1:00 – 2:00Keri Romanufa, IBM
Latest from the lab: V11.5.7
2:00Raffle for free pass to IDUG 2022 North America Conference
(sponsored by IBM)