Articles & Content

Archives

Stopping Unwanted Access Path Changes Before Disaster Strikes (G08)

Topic: 2008 EU

Subtopic: DB2 for z/OS



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



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.