Application performance & design 2008

Objectives:
Get more knowledge about how DB2 processes applications. With this knowledge tune applications for maximum performance.

Outline:
Part 1 DB2 Accounting trace
DB2 trace: classes & destinations
What is (not) in the DB2 accounting record
Nested activity (Stored Procedures, UDFs & Triggers)
Your Performance Indicators
CPU
Getpages
Wait time (not lock)
Lock time
IO's
Sort

Part 2 SQL Access Path
Explain: What does this (not) tell you
DSNSTMT table, use it!
Can the statement be improved?
Tuning toolbox
Groundrules for tuning
SQL Tuning
Forcing DB2 (optimize for / Hints)
Optimizer rewrite, when and how
Asking DB2 to reconsider
More and better stats
Bad thing you should not consider
Parallelism, why and why not!
How about dynamic SQL?

Part 3 Hints and tips for a better performance
Better SQL
Beter Database design
Improving your application logic
Batch Issues

Full Abstract:
There are many, many things that influence your performance. Where to find your performance indicators? How to interpret them?
This seminar looks at collecting and interpreting performance figures, looks at alternatives and discusses what should be done in order to obtain better performance. The last few releases of DB2 gave us some great things (e.g. multi row insert and fetch, and volatile tables). We will review these things in order to improve our applications. You will go home with some new idea's to improve your application.