Articles & Content

Archives

Getting the most out of your DB2 Storage Pools (A08)

Topic: 2006 EU

Subtopic: DB2 for z/OS



DATE: 2006-10-3 (16:45 - 17:45)
SPEAKERS: Steve Thomas (BMC Software)

While there has always been a justified focus on Tuning DB2 Bufferpools, there are a number of other important Storage Pools used by DB2 for z/OS including the RID Pool, the EDM Pool and the SORT Pool. This presentation describes what information DB2 saves in each of these primary storage areas and explains how this is used. We will discuss the various methods which can be used to monitor Pool usage and to determine whether they are sized correctly together with the potential impact on Application and overall System Peformance if they are sized incorrectly. The presentation finishes with an explanation of the impact made by the introduction of 64 bit storage and the changes introduced in DB2 Version 8.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

Overview of DB2 Storage Pools and their uses

What happens if Storage Pools are sized incorrectly?

How to monitor and tune DB2 Pools

Impact of DB2 V8 and the availability of 64 bit storage

Recommended Practices, Hints and Tips



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.