This article takes a detailed look at DB2 buffer pool management, an important performance consideration. The goal is to leverage virtual storage so you can keep application data closer at hand and eliminate physical I/Os—still the biggest component of DB2 application response time. The benefit is an improvement in overall service levels, with a reduction in CPU cycles and elapsed time to the user. With DB2 V8, buffer pool virtual storage constraints disappeared as buffer pools were moved above the bar, so you’re no longer concerned with virtual storage constraints. The primary concern is…

Read full article →

Table of Contents