The Basics of Db2 Buffer Pools

Db2 buffer pools are likely the largest single user of memory in your z/OS systems, and their efficient operation is key to Db2’s ability to service your business, so understanding their role and proper configuration is an important topic for any site that has Db2.

In this Watson and Walker Tuning Letter Reprint, Sally Mir dives into the SMF type 100 records to see what insights they offer into Db2 buffer pools. This article is appropriate for anyone that would like to know more about Db2 buffer pools, whether you are a Db2 newbie, an experienced Db2 system programmer or a database administrator.

To access this article reprint, please complete the form.

[This document is reprinted with permission from Watson and Walker. It originally appeared in Cheryl Watson’s Tuning Letter 2022 No. 1)