Articles & Content


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

Topic: DB2 for z/OS

Subtopic: 2007

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

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.