Tuning database manager settings

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

  1. 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
  2. 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


Feedback