Home > DB2 for z/OS > Tuning the DB2 Pools (Buffer, EDM, RID & Sort)

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

Course Code:	DZOBUF
Duration:	1 day
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.
Detailed Outline

Course Schedule