DB2 for z/OS

Dynamic Statements Cache: Everything You Need To Know (B05) 

May 13, 2009 03:00 PM

DATE: 2009-5-13 (09:45 AM - 10:45 AM)
SPEAKERS: Namik Hrle (IBM Boeblingen Lab)

The use of dynamic SQL continues to grow. Enterprise packaged applications as well as web applications use almost exclusively this flexible way of accessing databases. However, the flexibility is coupled with additional challenges when it comes to resources utilization, performance monitoring and tuning of SQL statements.This presentation focuses on dynamic statements cache - the key factor of a well performing dynamic statements environment. It covers all the relevant aspects of the statements cache: how it works, how to control its CPU and memory utilization, and how to monitor and tune it.

EXP. LEVEL: Beginner,Intermediate,Advanced


Detail understanding of how dynamic statements cache works

Choosing the optimal caching mode

Virtual storage impact and ways to avoid shortages

Common access path problems and solutions

Monitoring and tuning in dynamic statements cache environment

pdf file
NA09B05.pdf   5.35 MB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.