Articles & Content

Archives

Understanding and Tuning Page Cleaning in DB2 (C17)

Topic: DB2 for LUW

Subtopic: 2011



Transactions that insert, update, or delete rows in a table modify pages in the DB2 buffer pool and leave them behind as "dirty pages". Eventually, DB2 needs to write those dirty pages to their respective table space. This process is known as page cleaning and can have a critical impact on write intensive applications. Insufficient as well as overaggressive page cleaning can degrade performance. There are various conditions that can trigger DB2 to write dirty pages to disk asynchronously. Likewise, a variety of tuning knobs exist to influence when these conditions are met and page cleaning kicks in. This presentation provides an introduction to DB2's page cleaning mechanism and explains the effects of the relevant configuration parameters. You will learn how to monitor DB2's page cleaning behavior, how to detect inefficient page cleaning, and how to take corrective action that improves insert, update, and delete performance.



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.