IBM Support

How to stop the db2acd (db2hmon) process in DB2 Version 9.x

Question & Answer


Question

The db2acd process in DB2 Version 9.x will still run when database configuration parameters HEALTH_MON and AUTO_* are set to OFF

Cause

DB2® Version 9.x process db2acd is a single process that runs in parallel for both health monitor and automatic maintenance functions.

When HEALTH_MON=OFF and AUTO_* database configuration parameters are set to OFF, db2acd will still wakeup approximately every 2 hours to check for active database automatic maintenance.

Answer


Setting registry variable DB2_FMP_COMM_HEAPSZ to 0 will prevent db2acd from starting. This means no set is created, and as a result, no fenced routines can be invoked. It also means that the health monitor and the automatic database maintenance functionality (such as automatic backups, statistics collection, and REORG) will be disabled since this functionality relies on the fenced routine infrastructure.

If DB2_FMP_COMM_HEAPSZ is not (cannot be) set to 0, we cannot disable db2acd completely due to its original design. The db2 system controller (db2sysc process) will restart db2acd process if it is killed and this checking is done every 15 minutes.

Note: Setting DB2_FMP_COMM_HEAPSZ=0 will prevent ALL non-SQL routines from executing. This includes built-in DB2 routines and user routines as well!!

For more detail on setting DB2 registry variable and DB2 Database Manager Configuration, please see section "Related Information".

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Database Objects\/Config - Instance","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21259046