Articles & Content


Understanding and Tuning Page Cleaning in DB2 (C04)

Topic: 2011 NA

Subtopic: DB2 for LUW

DATE: 2011-5-3 (04:30 PM - 05:30 PM)
SPEAKERS: Matthias Nicola (IBM Silicon Valley Lab)

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.

EXP. LEVEL: Beginner


Understand synchronous and asynchronous page cleaning in DB2.

Learn how to interpret specific counters in the DB2 snapshot monitor to assess the efficiency of page cleaning in your database.

Learn how several DB2 configuration parameters affect page cleaning behavior.

Learn how to avoid synchronous page writes and how to tune for efficient page cleaning.

Understand how page cleaning is related to the size of log files and the time required for database recovery, and how to choose proper trade-offs.

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.