Error "The command specified for attribute MonitorCommand is NULL" reported by db2haicu
db2haicu may report this error "The command specified for attribute MonitorCommand is NULL" in db2diag.log during automation setup.
You may see the following error in db2diag.log when db2haicu is used to setup an automated cluster environment. This error indicates a problem accessing the HA policy scripts. The HA policy scripts are stored under /usr/sbin/rsct/sapolicies/db2 on each node of the cluster. It could be a bad permission issue or scripts may not exist.
2009-04-07-18.104.22.1682007-240 E148879A798 LEVEL: Error
PID : 1532088 TID : 1 PROC : db2haicu
INSTANCE: inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaAddResource, pr
MESSAGE : ECF=0x90000542=-1879046846=ECF_SQLHA_CREATE_GROUP_FAILED
Create group failed
DATA #1 : String, 35 bytes
Error during vendor call invocation
DATA #2 : unsigned integer, 4 bytes
DATA #3 : String, 21 bytes
DATA #4 : unsigned integer, 8 bytes
DATA #5 : signed integer, 4 bytes
DATA #6 : String, 172 bytes
Line # : 6531---stgdb2: 2661-011 The command specified for attribute MonitorComm
and is NULL, not a absolute path, does not exist or has insufficient permissions
to be run.
Usually this is caused by an incomplete install or by post-install modifications to the files in that path.
Diagnosing the problem
Look in db2diag.log.
Resolving the problem
To fix this problem, run a utility called db2cptsa as user 'root' that copies these scripts from DB2 install image to /usr/sbin/rsct/sapolicies/db2 (ensure this is done at each node of the cluster).
On AIX, you can find this utility under /opt/IBM/db2/V9.5/install/tsamp
Sample output of db2cptsa:
/opt/IBM/db2/V9.5/install/tsamp # ./db2cptsa
DBI1099I The DB2 HA scripts for the SA MP Base Component were
successfully installed in /usr/sbin/rsct/sapolicies/db2.
You need DB2 HA scripts to use the IBM Tivoli System Automation for
Multiplatforms Base Component with DB2 database products for high
availability disaster recovery.
These DB2 HA scripts are located at /usr/sbin/rsct/sapolicies/db2. The
DB2 installer detects whether these DB2 HA scripts need to be installed
The DB2 installer successfully installed the DB2 HA scripts.
No action is required.
More support for:
DB2 for Linux, UNIX and Windows
High Availability - HADR
Software version: 9.5, 9.7, 10.1, 10.5
Operating system(s): AIX, Linux
Reference #: 1383142
Modified date: 14 August 2014
Translate this page: