Articles & Content

Archives

[B16] Access Path Repository: The new Hints in DB2 10

Topic: DB2 for z/OS

Subtopic: 2013



Optimization Hints have been available in DB2 since version 6, but its complex and weak implementation has caused using them not being very popular and not widely used. DB2 10 gives a new push to make the optimization hints more useable, with the introduction of a new access path repository, that introduces new functionality and is the framework for future developments. Also, several new Db2 commands related are introduced. In this presentation, we will learn what has changed in DB2 10, and how to use it, with step by step descripcions and examples of old and new method. Also, the Access Path Repository will be explained and used in detail.



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.