Articles & Content
Topic: DB2 for z/OS
DATE: 2008-10-13 (11:15 - 12:15)
SPEAKERS: Thomas Baumann (Swiss Mobiliar)
Dynamic Queries use many memory resources to back dynamic statement caches, buffer pools etc.. The new 64bit systems offer a large amount of tuning opportunities, and many possibilities to waste memory.This presentation takes you from an overview of cache usage, dives into the caches to detect meaningfuel information, comes up with a 'memory efficiency score', and shows you how to estimate the benefit you could expect if you would install 2GByte of additional memory.All with a specific focus on dynamic SQL queries.
EXP. LEVEL: Beginner,Intermediate,Advanced
Overview of dynamis SQL's usage of memory
Queries and commands to get meaningful memory information
Apply a 'memory efficiency check' at the participant's site
Experiences at other sites
Predict the benefit of additional memory
Click Here to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.