Articles & Content

Archives

Best European Speaker: SQL and AccessPaths - "A DIY Way to Survive" for Both Static and Dynamic SQL (B09)

Topic: 2007 NA

Subtopic: DB2 for z/OS



DATE: 2007-5-9 (09:50 AM - 10:50 AM)
SPEAKERS: Frank Petersen (Bankdata)

This presentation will be a follow-up, yet stand-alone capable, to a presentation given at IDUG, Berlin 2005. Where that presentation (among other things) had some theoretically suggestions about what can be done to capture dynamic SQL and doing EXPLAIN of this; this presentation will be a walk-through of a physical implementation that Bankdata has made according to these suggestions. Bankdata has made first version of an implementation where we catch dynamic SQL and document the accesspath selections. This documentation is saved in a historical database for both dynamic AND static SQL. This solution will be described in detail, covering both how it was done, problems met and successes experienced (if any).

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

Understand the importance and problems inside dynamic SQL and accesspath selection

Understand the importance of documenting and saving explain information for a long time

Understand the pro's and con's of developing a homemade solution

Get inspiration as to what can be done and as to what to look after in vendor-solutions

Inspiration is the keyword



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.