DB2 database manager settings

The database manager settings are set at the instance level. The settings that affect performance involve memory size, how fenced processes behave, and whether the database instance is monitored.

The following values are provided for tuning the database manager settings in DB2®:
Database manager settings Value for performance tuning Descriptions
RQRIOBLK 65535 Sets the size of the communication buffer between remote applications and their database agents on the database server.
HEALTH_MON OFF Specifies whether an instance, the associated databases, and database objects are monitored.
MON_HEAP_SZ AUTOMATIC Specifies the amount of the memory, in 4-KB pages, that is allocated to database system monitor data. The AUTOMATIC value means that the monitor heap size can increase as needed until the limit of the instance memory is reached.
KEEPFENCED NO Indicates whether a fenced mode process is kept after a fenced mode routine call is complete. If you have many fenced processes, you can set the KEEPFENCED setting to YES, but then you must monitor your memory usage.
AGENT_STACK_SZ For UNIX or Linux operating systems: 1024
For Windows operating system: 1000
Determines the amount of virtual memory, measured in 4-KB pages, that is allocated for each agent.


Feedback