10:00 – 11:00 | Dale McInnis, IBM Running Db2 PureScale in a Public Cloud |
11:00 – 11:05 | Break |
11:05 – 12:05 | David Kalmuk, IBM The Latest in Advanced Performance Diagnostics for SQL |
12:05 – 1:00 | Lunch Break |
1:00 – 2:00 | John 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:00 | Martin Hubel The Data Pioneer: Recovery |
11:00 – 11:15 | Break |
11:15 – 12:15 | Ember Crooks Db2 Basics: Monitoring and Troubleshooting Db2 |
12:15 – 1:00 | Lunch Break |
1:00 – 2:00 | Keri Romanufa, IBM Latest from the lab: V11.5.7 |
2:00 | Raffle for free pass to IDUG 2022 North America Conference (sponsored by IBM) |
The Data Pioneer: Recovery
Download PDF
Watch recording (logged in Tridex members only)
Session title: The Data Pioneer: Recovery
Session abstract: Data pioneers are those of us that have to establish Db2 environments from scratch. Understanding recovery is a necessary skill for the Data Pioneer, and it arguably the most important skill.
The Data Pioneer: Recovery
Registered Tridex members can also watch a recorded version of this presentation. Please make sure you’re logged in to access this protected content. Continue reading “The Data Pioneer: Recovery”
Db2 Basics: Monitoring and Troubleshooting Db2
Download PDF
Watch recording (logged in Tridex members only)
Session title: Db2 Basics: Monitoring and Troubleshooting Db2
Session abstract: While aimed at those who have been working with Db2 on Linux, UNIX, or Windows for two years or less, this presentation shares Ember’s approach to monitoring and troubleshooting Db2, and goes fairly deep in some areas.
Continue reading “Db2 Basics: Monitoring and Troubleshooting Db2”
Db2 Basics: Monitoring and Troubleshooting Db2
Registered Tridex members can also watch a recorded version of this presentation. Please make sure you’re logged in to access this protected content. Continue reading “Db2 Basics: Monitoring and Troubleshooting Db2”
Latest from the lab: V11.5.7
Download PDF
Watch recording (logged in Tridex members only)
Session title: Latest from the lab: V11.5.7
Session abstract: V11.1 first shipped in April 2016. It introduced a new paradigm of continuous delivery to Db2 releases. We will start with a review of V11.1 including recent mod 4 functionality.
Latest from the lab: V11.5.7
Registered Tridex members can also watch a recorded version of this presentation. Please make sure you’re logged in to access this protected content. Continue reading “Latest from the lab: V11.5.7”
Tridex Db2 LUW – December 2nd 2021 agenda
09:30 – 10:30 | Calisto Zuzarte, IBM Tuning ETL Performance |
10:35 – 11:35 | Toby Haynes, IBM The Next Stop(s) in Db2 Pacemaker HA Solution Journey |