MAXIMUM_ALLOCATIONS
Use the MAXIMUM_ALLOCATIONS parameter in CQMPARMS to control the global shared memory allocation behavior of your Query Monitor subsystem.
- Description
- The maximum amount of global shared memory in megabytes (n) that can be
allocated by Db2 Query
Monitor for internal Integrated Storage
Manager spaces. Note: The value you specified for the SMEM_SIZE parameter must be 4 times greater than that specified for the MAXIMUM_ALLOCATIONS parameter. If you specify a value less than this, then Db2 Query Monitor will automatically adjust the SMEM_SIZE value to be equal to 4 times the MAXIMUM_ALLOCATIONS value.
- Syntax
- MAXIMUM_ALLOCATIONS(n)
- Default
- 2048
- Range
- Integers in the range 512 - 32768
- Example
- MAXIMUM_ALLOCATIONS(4096)