15.3. Database-Level Shared Memory

When you issue the activate database command or connect to a database for the first time, DB2 automatically allocates the database-level shared memory (see Figure 15.3). This memory caches the object pages that are being manipulated to control concurrency on the rows of data, ensure transactional integrity for all operations on the database, and so on.

Figure 15.3. Database shared memory
[View full size image]

The components of database shared memory include:

  • The database buffer pool(s)

  • The lock list

  • The shared sort area (if intra-partition parallelism is enabled)

  • The database heap, which also includes

    - The log buffer ...

Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial