Topic: DB2 for z/OS
Runstats has always been a challenge in terms of what syntax to use, how much statistics to collect and how frequent to collect these statistics. The past couple of DB2 releases have introduced some interesting features which can assist you in several ways to both automate and figure out which statistics the Optimizer would like to see in order to make better recommendations. We will look into the RUNSTATS profiles and the two different FEEDBACK tables populated by the Optimizer.
Click Here to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.