MAXIMUM_ALLOCATIONS
Use MAXIMUM_ALLOCATIONS to specify the maximum amount of global shared memory that Db2® allocates for internal Integrated Storage Manager spaces.
- Required
- No
- Default
- 2048 megabytes
- Permitted Values
- 512 - 32768 megabytes
- Description
-
Use this parameter in conjunction with the SMEM_SIZE parameter. The SMEM_SIZE parameter value must be equal to or greater than four times the MAXIMUM_ALLOCATIONS parameter value. If you specify a SMEM_SIZE value less than four times the value of MAXIMUM_ALLOCATIONS, then Db2 automatically adjusts the SMEM_SIZE value to be four times greater than the MAXIMUM_ALLOCATIONS value.
If Db2 and Db2 Query Monitor are simultaneously monitoring the same Db2 subsystem, the MAXIMUM_ALLOCATION value(s) from the respective product (either Query Monitor or STAP) is used to limit the amount of memory allocated from the shared memory objects. The MAXIMUM_ALLOCATIONS values for the two products do not have to match.
- Notes
- None
- Syntax
-
MAXIMUM_ALLOCATIONS(n) - Example
-
MAXIMUM_ALLOCATIONS(2048)