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”

Db2 Historical Monitoring

Download PDF
Watch recording (logged in Tridex members only)

Session title: Db2 Historical Monitoring

Session abstract: Introducing db2histmon, the newest addition to the family of problem determination tools. This lightweight technology allows you to collect historical data on your database, helping especially with performance or workload problem root cause analysis even for past occurrences, greatly reducing the need to recreate the problem with additional trace techniques enabled. 

Continue reading “Db2 Historical Monitoring”

Db2 – Ready for modernized deployments and workloads

Download PDF
Watch recording (logged in Tridex members only)

Session title: Db2 – Ready for modernized deployments and workloads

Session abstract: There are two major modernization dimensions.  Modern deployments and modern workloads.  Iin this session we will discuss what Db2 is doing to help our clients modernize their deployments and to ensure Db2 is ready to handle modern workloads.  This will include Db2’s investment in multi-model, NoSQL, mixed workloads, containerization and cloud. 

Continue reading “Db2 – Ready for modernized deployments and workloads”