Articles & Content

Archives

DB2 10 for z/OS - tips and tricks to influence and manage SQL optimization (A11)

Topic: 2011 AU

Subtopic: DB2 for z/OS



In this presentation you will learn how to identify what statistics have been gathered that help influence the optimizer through the new runstats profile option. At times you may find that a once optimal access path is no longer being chosen. You have the ability to influence the access path chosen at the statement level as well as user level through optimization hints. However, you may find that you really don’t want to influence the optimizer through hints and just want the ability to fallback to the original access path or the last good access path through plan management. The use of hints and plan management had room for improvement. You will learn about these improvements through access plan stability and instance-based statement hints.



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.