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

The Latest in Advanced Performance Diagnostics for SQL

Download PDF

Watch recording (logged in Tridex members only)

Session title: The Latest in Advanced Performance Diagnostics for SQL

Session abstract: The Db2 family of products including Db2, Db2 Warehouse, and BigSQL provide a number of important features for diagnosing and solving your SQL problems. Through a series of practical examples, we will bring you up speed on the latest capabilities available for SQL diagnostics and show you how you can leverage them to solve query problems in your own environment.

Continue reading “The Latest in Advanced Performance Diagnostics for SQL”

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.

Continue reading “Desperate Measure – How to Relieve the Db2 Optimizer of Its Duties”