Articles & Content


DB2 Application Development from the Programmer's Point of View (G07)

Topic: 2007 NA

Subtopic: DB2 for z/OS

DATE: 2007-5-8 (01:40 PM - 02:40 PM)

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!

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.