Articles & Content
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
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.