IBM Support

Error "The command specified for attribute MonitorCommand is NULL" reported by db2haicu

Technote (troubleshooting)


Problem(Abstract)

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.

Document information

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: