Access Path Recovery for Db2 11 + 12 using RUNSTATS Rescue Still important in an AI/ML world?

Tuesday June 9th, 2020

10 am (EDT) – New York
04 pm (CET) – Berlin – Paris – Madrid

Webinar presented by SEGUS & SOFTWARE ENGINEERING

In this webinar I will show how you can easily restore a prior access path of your dynamic/static application.

Runstats Rescue – The Real World
Join me for a brief overview of which statistics are used by the Db2 optimizer how they correlate to each other and why Db2 catalog statistics, and RUNSTATS, are still important in todays AI and Autonomic world.

I’ll also introduce RUNSTATS Rescue and show you how to use it for Dynamic and Static SQL access path recovery. This will include the prerequisites, the straight forward restore process and highlighting the differences.

Last, but not least I’ll share real world results from Fiducia & GAD IT AG, Datev eG. and REWE Group covering for example:

  • Matching index access to non-matching index access
  • Table join order changes
  • Error SQLCODE returned – Not possible by a RUNSTATS – Think again!


Speaker biography

Roy Boxwell has more than 34 years of experience in MVS, OS/390, and z/OS environments – 31 of those in Db2. He specializes in installation, migration, and performance monitoring and tuning. Roy leads the SEG development team responsible for the real time database maintenance solutions. He is also an active participant, speaker and contributor on the IDUG Db2 Listserv and sends out a monthly Db2 z/OS Newsletter.