Articles & Content


C11 - Take a Hint with DB2 for Linux, UNIX and Windows Optimization Profiles

Topic: 2015 EMEA

Subtopic: DB2 for LUW

Optimal query access plans are essential for good data server performance and it is the DB2 for Linux, UNIX and Windows query optimizer's job to choose the best access plan. However, occasionally no amount of statistics or tuning is enough to get the access plan you want. Or your application is effectively down, due to a poorly-performing query, and there isn't time to implement best practices. When these situations arise, DB2 optimization profiles can be used to correct the access plan and get your application performing well again, quickly. DB2 optimization profiles can specify various aspects of an access plan, can control automatic query rewriting or can control the optimizer's plan search space. This presentation will show you what options are available and how to use them.

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.