An additional identifier to help determine
the memory pool for which
monitor data is returned.
- Element identifier
- pool_secondary_id
- Element type
- Information
Table 1. Snapshot Monitoring Information| Snapshot Level |
Logical Data Grouping |
Monitor Switch |
|---|
| Database Manager |
memory_pool |
Basic |
| Database |
memory_pool |
Basic |
| Application |
memory_pool |
Basic |
Table 2. Event Monitoring Information| Event Type |
Logical Data Grouping |
Monitor Switch |
|---|
| Database |
event_dbmemuse |
- |
| Connection |
event_connmemuse |
- |
- Usage
- Use together with pool_id to determine
the memory pool for which monitor
data is returned. Data for pool_secondary_id only appears when necessary.
For example, it appears when the pool_id indicated is Buffer Pool
Heap to
determine which buffer pool the monitor data relates to.
When a database
is created, it has a default buffer pool, called IBMDEFAULTBP,
with a size determined by the platform. This buffer pool has a secondary
id
of "1". In addition to this buffer pool and any buffer pools that
you create, a set of system buffer pools are created by default, each
corresponding
to a different page size. IDs for these buffer pools can appear in
snapshots
for pool_secondary_id:
- System 32k buffer pool
- System 16k buffer pool
- System
8k buffer pool
- System 4k buffer pool
DB2 Version 9.7 for Linux, UNIX, and Windows