Articles & Content

Archives

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

Topic: DB2 for z/OS

Subtopic: 2006



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



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.