Articles & Content

Archives

Stopping Unwanted Access Path Changes Before Disaster Strikes (G08)

Topic: DB2 for z/OS

Subtopic: 2008



DATE: 2008-10-14 (16:45 - 17:45)
SPEAKERS: Mike Perry (BMC Software)

Many things can cause detrimental access path changes, such as running RUNSTATS and migrating to a new DB2 version. This session shows how you can use BMC's SQL Performance for DB2 solution to predict access path changes before they can hurt you. You will learn techniques for gathering the dynamic SQL text in a workload, explaining the text in different environments, and comparing access paths. The session covers exactly what constitutes a "worse" access path.

EXP. LEVEL: Intermediate

OBJECTIVES:

Discuss BMC's SQL Performance solution and how it can be used to identify access path changes that can negatively impact performance

Discuss efficiently collecting dynamic SQL statment text for access path analysis

How to generate before and after SQL access path information for your dynamic workload

Comparing before and after access path information to identify access path changes that can degrade performance

Discuss what constitutes a potential degradation in performance driven by new access paths



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.