O'Reilly logo

Understanding DB2®: Learning Visually with Examples, Second Edition by Dwaine R. Snow, Michael Dang, Xiaomei Wang, Raul F. Chong

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 16. The DB2 Memory Model

It is important that you understand how and when DB2 allocates and utilizes its memory to enable you to design and set up your applications optimally so they won’t interfere with the database on the server.

In this chapter you will learn about:

  • How and when DB2 allocates memory

  • DB2’s use of shared and private memory

DB2 Memory Allocation: The Big Picture

DB2 allocates memory for three different types of operations.

  • Instance-level operations: DB2 allocates memory for instance-level operations such as accepting connection requests, for starting up support to activate a database, and for interpartition communication if you have a multi-partition system. This is known as instance-level shared memory since it is shared by ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required