Articles & Content

Archives

XA23 - Too many fights in your marriage with Runstats – get your life back.

Topic: DB2 for z/OS

Subtopic: 2015



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.