The database manager settings that affect performance set
the sizes of memory spaces, control the behavior of fenced processes,
and specify whether the instance is monitored.
Procedure
- For all operating systems, in the command prompt on the
server on which DB2® is
installed, run the following commands:
db2
update dbm cfg using RQRIOBLK 65535
db2
update dbm cfg using HEALTH_MON OFF
db2
update dbm cfg using MON_HEAP_SZ AUTOMATIC
db2
update dbm cfg using KEEPFENCED NO
- Set the amount of virtual memory that is allocated for
each agent:
Option |
Description |
For the UNIX or Linux operating
system |
Run the following command: db2 update
dbm cfg using AGENT_STACK_SZ 1024
|
For the Windows operating
system |
Run the following command: db2 update
dbm cfg using AGENT_STACK_SZ 1000
|