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 13 for z/OS Technical Overview”Modern Db2 for z/OS Physical Database Design – 2022 Edition
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”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”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 “Running Db2 PureScale in a public cloud”The Latest in Advanced Performance Diagnostics for SQL
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”Desperate Measure – How to Relieve the Db2 Optimizer of Its Duties
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”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”Monitoring Alerts at Mastercard
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”Ready Player One for Db2 13!
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!”Tuning ETL Performance
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.