Articles & Content

Archives

Parallelism Strategies in the DB2 Optimizer (A05)

Topic: 2008 NA

Subtopic: DB2 for LUW



DATE: 2008-5-20 (09:15 AM - 10:15 AM)
SPEAKERS: Calisto Zuzarte (IBM Toronto Lab)

If you would like to improve query performance, it often helps to understand the internals of the optimizer. Ever wondered how we handle optimization in a shared nothing environment (using DPF the database partitioning feature) ? ... or when one has intra-partition parallelism turned on ? ... or how the optimizer handles parallelism in a federated environment using Websphere II ?

EXP. LEVEL: Intermediate

OBJECTIVES:

There is some level of frustration when users do not understand how the optimizer works and they have a performance problem. The main objective is to create an understanding of the optimizer so that users do not have to treat it as a black box.

Describe how the optimizer handles parallelism in a DPF (database Partitioning Feature) environment

Describe how the optimizer handles parallelism with intra-query parallelism turned on (using SMP - Symmetric Multi processor systems)

Describes how the optimizer handles parallelism in a federated environment

Make query peformance problem determination easier.



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.