Troubleshooting
Problem
db2haicu may report this error "The command specified for attribute MonitorCommand is NULL" in db2diag.log during automation setup.
Symptom
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-11.41.27.432007-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
obe:1600
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
22
DATA #3 : String, 21 bytes
db2_inst1_stgdb2_0-rg
DATA #4 : unsigned integer, 8 bytes
1
DATA #5 : signed integer, 4 bytes
98343
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.
Cause
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.
Explanation:
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
or updated.
The DB2 installer successfully installed the DB2 HA scripts.
User response:
No action is required.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21383142