21

Data Replication is one of the actual emerging concern for the modern DBA.
From the standard solutions to the Hardware and Software variations, from the point in time to the asynchronous copy, this presentation will take a walk though the complexity and diversity of data replication.

From the first day DB2 has been known as a system that needs a lot of resources.
For some users in the world 2 GB is yet not enough but they will have to wait intil DB2 V8 before they can break through that limit.
DB2's hunger for memory doesn't seem to stop. Where does all this momory go?
Klaas will discuss all pieces of DB2 that will storage like bufferpool, rid pool, sort pool etc. Can we control DB2's hunger?
What happens if we tweak the parameters? Klaas will discuss where to look for performance figures.

Dynamic SQL has a bad reputation.
Why? Is it really that bad?
Many users don't even know what dynamic SQL really is.
Ask a ten users and get ten (wrong) answers to the question: what is dynamic SQL?
Klaas will review what dynamic SQL is and why it is regarded as "bad".
But it seems dynamic SQL is used more and more. ODBC and SAP are good examples.
What can we do to boost the performance of dynamic SQL?
You might have heared about the dynamic SQL cache.
How does it work and when can we benefit from it or more important when doesn't it work for us...

DB2 V8 is the largest DB2 release ever. It includes numerous exciting features from all areas of database exploitation: SQL, database administration, performance.
There are some fundamental changes in DB2 architecture.
This presentation provides an overview of V8 features that are particularly interesting to database administrators and application programmers.