Articles & Content

Archives

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

Topic: 2009 EU

Subtopic: DB2 for z/OS



DATE: 2009-10-6 (14:15 - 15:15)
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

OBJECTIVES:

Get detailed understanding of how dynamic statements cache works

Assist users to choose the optimal caching mode

Beware of virtual storage impact and ways to avoid shortages

Analyze common access path problems and solutions

Provide guidance on how to monitor and tune in dynamic statements cache environment



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.