Application performance & design 2008

Date: 
Thursday, 26 June, 2008 (All day)
Speaker: 
Klaas Brant

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.

 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2020

VIRTUAL EVENT - 25th - 27th November 2020