The Evolution of the Memory Model in IBM DB2 for Linux, UNIX and Windows
With the introduction of the Self Tuning Memory Manager in DB2 V9 and the new thread-based architecture in DB2 V9.5 the memory model of DB2 has undergone several modifications. This paper explains how and why the memory model evolved in DB2 V9 and V9.5 compared to DB2 UDB V8. Without explaining all details of the DB2 memory management it concentrates on the basic concepts and terminology and considers especially the most important configuration parameters, their settings and how they changed over time. The focus is on the Linux and UNIX platforms as they are affected by the change to the thread-based architecture in DB2 V9.5.