Articles & Content

Archives

Memory Management for Dynamic SQL (B08)

Topic: 2008 NA

Subtopic: DB2 for z/OS



DATE: 2008-05-20 (04:00 PM - 05:00 PM)
SPEAKERS: Thomas Baumann (Swiss Mobiliar)

Dynamic queries use many memory resources to back dynamic statement caches, buffer pools etc.. 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 meaningful information, comes up with a ‘memory efficiency score’, and shows you how to estimate the benefit you could expect if you install 8Gbyte of additional memory.All with a specific focus on dynamic SQL queries.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Overview of dynamic SQL's usage of memory

Queries and commands to get meaningful memory information

Apply a 'memory efficiency check' at the attendee's site

Benefit from memory management experiences made at other sites

Predict the benefit of additional memory



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.