Bonnie Baker's Course Offerings - Things I Wish They'd Told Me 8 Years Ago

Things I Wish They'd Told Me 8 Years Ago - Part 5 (Basic to Intermediate)

Course: BB05

Fifth in a Series of Seminars for

DB2 Application Developers

presented by

Bonnie K. Baker

This seminar continues the saga with all new ideas, new tips, and new techniques for improving program performance. Easy-to-understand examples are used to simplify difficult concepts so that the programmers can apply those concepts to program logic and SQL in order to improve performance. New features available in V5 and V6 will be emphasized. Hints and tips are given at all levels, for those who have used DB2 for years as well as those who just met DB2. This seminar is based on DB2 for the MVS/OS390 but those using other platforms may find some of the information beneficial.
The agenda includes:

Program execution - V6 differences
Program preparation - Bind vs Rebind and V6 differences
Retrieving data - both rid and data sort required
Retrieving data - multiple index access
Program execution - more info on stage 2 predicates
What does this have to do with performance?
Some more referential integrity issues
Lock avoidance - the final details
Lock avoidance - the final details
Data integrity exposures
Index overhead
Read-only program commits - why?
What is a SIX lock?
Alter to add column impact
Alter to add column impact
Little things: system, design, programming, and SQL tips

Program execution - V6 differences

Program preparation - Bind vs Rebind and V6 differences

Retrieving data - both rid and data sort required

Retrieving data - multiple index access

Program execution - more info on stage 2 predicates

What does this have to do with performance?

Some more referential integrity issues

Lock avoidance - the final details

Lock avoidance - the final details

Data integrity exposures

Index overhead

Read-only program commits - why?

What is a SIX lock?

Alter to add column impact

Alter to add column impact

Little things: system, design, programming, and SQL tips