DB2 V9 Performance and Tuning for Programmers

    

Summary:
This course is designed for Application Programmers and Programmer/Analysts who will be using SQL statements in a high level programming language to manipulate DB2 tables. This course covers differences between versions 7 & 8 of DB2 UDB.

Duration:
3 Days/Lecture & Lab

Audience:
This course is designed for Application Programmers and Programmer/Analysts who will be using SQL statements in a high level programming language to manipulate DB2 tables.

Topics:

• Application Tuning
• SQL Statements That Can Affect Performance
• EXPLAIN Function
• Simple and Complex Access Paths
• Index Structure, Design and Usage
• DB2 Buffer Pools and Their Impact on Performance

Prerequisites:
Students must have experience coding in one of the programming languages listed: COBOL, PL/I or C. Students must also have experience in TSO/ISPF and DB2 file structures.

Last Update: February 10, 2012