Tuning the DB2 Pools (Buffer, EDM, RID Sort)

Audience:Administrators, System Administrators and Capacity Planners.Prerequisites:Working knowledge of the five (5) DB2 address spaces and DB2 objects and data sets.Summary:This course explores useful ways to monitor and tune the DB2 virtual, EDM, RID and SORT pools. After discussing the constraints of the ssnmDBM1 address space and its 2GB (until z/OS) addressing limit, the presentation focuses on the following:

• Buffer pools vs. hiper pools
• Buffer pools vs. data spaces
• Synchronous vs. asynchronous reads and writes
• Table space/index space buffer assignment
• Thresholds
• Size and number of buffers
• Page stealing algorithms
• Using online commands to monitor and tune buffers
• Using buffer pool statistics to monitor and tune buffers

Objectives:Upon completion of this presentation, the participant should be able to use monitoring tools such as the -DISPLAY BUFFER POOL command to monitor and tune the DB2 buffers.