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”

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)