Articles & Content
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
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.