Archives

Performance Topics for DB2 Application Tuners (F08)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2009

---

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?

---

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.