Are you Just Gonna Play in the Pool...or Own It...Bufferpool that Is

Project and Program: Information Management, Database

Tags: Proceedings , SHARE Sacramento 2018 , 2018

There have been many changes to buffer pool behavior, performance, and management across recent DB2 releases. With the staggering increase in available real memory in recent IBM Z machines you could actually reach Db2's architectural limit on size (prior to V12). This presentation will walk through several major enhancements as well as if they are right for you, and how to measure them. From Page Fix to Autosize and what the SLRU statistics mean to you... Understanding the impact of your tuning activities is just as important as undertaking them in the first place.-Adrian Burke-IBM Corporation

Back to Proceedings File Library