Loading…
← Back to schedule
D16 | Access Path Management (with and without AI): Best Practices for influencing the Db2 for z/OS Query Optimizer and for Minimizing the Risk of Access Path Changes
Thursday June 12, 2025 11:20am - 12:20pm EDT
Techwood
Db2 for z/OS provides several features to influence the query optimizer. Learn how to leverage these features to improve query performance, and to avoid access path changes that introduce the risk of regression after a BIND, REBIND or full PREPARE. Also, should an access path regression occur, learn what your options are to quickly restore performance.The session includes how Db2ZAI works with the Db2 optimizer to improve query performance while minimizing the risk of access path regression.
Speakers
avatar for Thomas Beavin

Thomas Beavin

Senior Software Engineer, IBM
Thomas Beavin joined IBM in 1986 as a Db2 developer working in the Utilities area.  In 1994 he joined the Db2 query optimizer development team, where he is still currently a member. He has designed features and written code for every release of Db2 since version 1 release 2.In recent... Read More →
Thursday June 12, 2025 11:20am - 12:20pm EDT
Techwood
  Technical Session, AI Data Mining and ML

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Tweet Share
Share Modal

Share this link via

Or copy link