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”

Monitoring Alerts at Mastercard

Download PDF

Watch recording (logged in Tridex members only)

Session title: Monitoring Alerts at Mastercard

Session abstract: Are you monitoring the right Db2 messages and codes?  Do you have automation setup to look at MSTR and page you if a critical issue arises? Are you looking at -904 (resource unavailable) conditions to see what needs to be fixed now, vs sometime later? Do you maintain a list of all Db2 messages and codes that are critical to the success of Db2 on z/OS?

Continue reading “Monitoring Alerts at Mastercard”

The Next Stop(s) in Db2 Pacemaker HA Solution Journey

Download PDF
Watch recording (logged in Tridex members only)

Session title: The Next Stop(s) in Db2 Pacemaker HA Solution Journey

Session abstract: This presentation focuses on the latest advancements in automated HA with Pacemaker as newly-crowned integrated cluster manager for Db2. A recap of features in V11.5.5.0, V11.5.6.0, and a glimpse into V11.5.7.0 and beyond will be provided. 

Continue reading “The Next Stop(s) in Db2 Pacemaker HA Solution Journey”