Articles & Content

Archives

Performance Topics for DB2 Application Tuners (F08)

Topic: 2009 EU

Subtopic: Cross Platform DB2 for z/OS & LUW



DATE: 2009-10-6 (15:45 - 16:45)
SPEAKERS: Sheryl Larsen (Sheryl M. Larsen, Inc.)

Luckily, tuning DB2 SQL is not needed as frequent as other RDBMSs. However, as SQL statements grow in length and/or complexity, minor flaws in cost-based optimization can surface. Come learn how and when to change the optimizerís mind in DB2 V8, DB2 9 and DB2 X. Topics like proper index design, when is extreme query re-write necessary, when is limited fetch not effective, and much more.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

Demonstrate when to change the DB2 Optimizerís Mind

Demonstrate how to change the DB2 Optimizerís Mind

Demonstrate how to design indexes for a Workload

Demonstrate when manual query re-write is necessary?

Demonstrate when Limited Fetch is not effective?



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.