Chapter 15
| A1: | The memory tracker and memory visualizer tools display DB2's memory usage at the instance, database, and agent levels. |
| A2: | The DATABASE_MEMORY configuration parameter allocates more shared memory than actually used to allow for the increase of the buffer pools, lock list, and so on, or for the creation of new buffer pools. |
| A3: | The package cache allows for the sharing and reuse of packages between applications. |
| A4: | The shared sort heap threshold is a hard limit for the concurrent amount of memory that can be used for shared sorts. |
| A5: | The log buffer is flushed to disk:
depending on which occurs first. Therefore, the longest time period between flushes of 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.
