Print this Page

DB2 for OS/390: Performance Issues in Application Programming

Abstract
(4 Days)

This course introduces students to performance issues in writing application programs using the DB2 database.  It provides students with insights into how they might substantially change program performance based on application design and programming techniques.

Audience

This course is open to anyone familiar with DB2 application programming and issues, the SQL language, and embedded SQL in application programming.  It does not assume any particular programming language.

Topics

• An overview of DB2 components

• Database, tablespace and indexing structures

• DB2 techniques for limiting physical I/O

• Joins vs. nested queries - How to control performance

• Indexing structures in detail

• Controlling performance through indexing choices

• WHERE clauses and their effect on performance

• Performance effects of ANY, EXISTS, CONT, etc.

• Internal conversions in DB2 and how to avoid them

• Optimization – filter factors and predicate cost estimates

• Using EXPLAIN to anticipate performance

• Reorganizations, utilities and performance effects

Supervised Exercises

Each day, the class sessions will be accompanied by a set of written/programming exercises designed to reinforce the classroom material.