Tri-State Db2 Technology Exchange
Db2 Users Group
Watch recording (logged in Tridex members only)
Session title: Modern Db2 for z/OS Physical Database Design – 2022 Edition
Session abstract: I presented in modern Db2 for z/OS database design for a TRIDEX meeting in 2015, and a lot has changed since then.
Continue reading “Modern Db2 for z/OS Physical Database Design – 2022 Edition”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 “Modern Db2 for z/OS Physical Database Design – 2022 Edition”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 “Running Db2 PureScale in a public cloud”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 Latest in Advanced Performance Diagnostics for SQL”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”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 “Desperate Measure – How to Relieve the Db2 Optimizer of Its Duties”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”Watch recording (logged in Tridex members only)
Session title: Ready Player One for Db2 13!
Session abstract: Hopefully, you haven’t missed the news – Db2 13 for z/OS has been announced! Are you ready for Db2 13? Migration details are already available and you should definitely start asking! This presentation will help you answer your initial questions about the Db2 13 migration.
Continue reading “Ready Player One for Db2 13!”Download PDF
Watch recording (logged in Tridex members only)
Session title: Tuning ETL Performance
Session abstract: This presentation looks at some general aspects for consideration with ETL workloads. Additionally, aspects that might improve the analytical query workloads including performance objects that might need to be established during ETL will be covered.
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”