Articles & Content

Archives

A12 - Access Path Repository: The new Hints in DB2 10 and What is new in DB2 11

Topic: 2014 EMEA

Subtopic: DB2 for z/OS



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, which introduces new functionality and is the framework for future developments. Also, several new DB2 commands related are introduced. In this presentation, we will learn how it has changed in DB2 10, and how to use it, with step by step descriptions and examples of old and new method. Also, the Access Path Repository will be explained and used in detail. What is new in DB2 11 for Access Path Repository will also be reviewed and will review performance considerations.



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.