The internally configured size of a memory pool in DB2® database system. The value is given in bytes.
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
Database Manager | memory_pool | Basic |
Database | memory_pool | Basic |
Application | memory_pool | Basic |
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Database | event_dbmemuse | - |
Connection | event_connmemuse | - |
To see if a memory pool is nearly full, compare pool_config_size to pool_cur_size. For example, assume that the utility heap is too small. You can diagnose this specific problem by taking snapshots at regular intervals, and looking in the utility heap section of the snapshot output. If required, the pool_cur_size might be allowed to exceed the pool_config_size to prevent an out of memory failure. If this occurs very infrequently, no further action is likely required. However if pool_cur_size is consistently close to or larger than pool_config_size, you might consider increasing the size of the utility heap.