Articles & Content
Topic: 2007 NA
Subtopic: DB2 for z/OS
DATE: 2007-5-8 (01:40 PM - 02:40 PM)
SPEAKERS: Boris Ioffe (HIGHMARK BCBS)
This presentation is designed for application developers by an application developer. Topics covered: We usually get the problem when it is too late or too expensive to fix it. How to use your business knowledge to write efficient SQL. What do you know about the data to choose the best path for your query? How you can get all necessary information from the plan table and DB2 catalog in a format you can read and understand.
EXP. LEVEL: Beginner,Intermediate,Advanced
Common data related problems in DB2 application
How to avoid data corruption in first place
Starting SQL tuning before writing anything
Predicting and avoiding performance degradation before it happens
How to write and use customized EXPLAIN for your applications
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.