Db2 database manager configuration parameters
IBM® Product Master requires certain DB2® database manager configuration parameters to be set before you install and use the product.
The following table shows the database manager configuration parameters and corresponding values
that must be set for use with Product Master. In each case,
the syntax of the command to update the parameter
is,
db2 update dbm cfg using <parameter> <value>| Parameter | Description | Value |
|---|---|---|
| MON_HEAP_SZ | The memory that is required for maintaining the private views of the database system monitor data is allocated from the monitor heap. Its size is controlled by the mon_heap_sz configuration parameter. |
|
| SHEAPTHRES | Private and shared sorts use memory from two different memory sources. The size of the shared sort memory area is statically predetermined at the time of the first connection to a database based on the value of sheapthres. The size must be at least two times the size of sortheap of any database hosted by the Db2 instance. |
|
Sample statements for updating database manager configurations:
update dbm cfg using MON_HEAP_SZ automatic
update dbm cfg using SHEAPTHRES 0
There is no requirement to update SHEAPTHRES for
new installations as 0 is the default value.