IBM Support

Create pureScale instance with db2icrt fails at DBI20009E

Technical Blog Post


Abstract

Create pureScale instance with db2icrt fails at DBI20009E

Body

The following error can be found in log files:

1) error in db2icrt log
ERROR: DBI20009E  Creation of SA MP resources for the database manager
instance, "db2inst1", has failed. The instance creation will be rolled back.

Rollback of instance "db2inst1" succeeded on hosts "host1,
host2"

ERROR: An error occurred while configuring the instance "db2inst1".

DBI20000E  A database manager instance could not be created as specified. A
rollback of the instance creation will be started.

Deletion of the RSCT peer domain, "db2domain_20170101094833", succeeded.

(2) db2diag.log has following error message:
timestamp           LEVEL: Severe
PID     : 12345                TID : xxx PROC : db2cluster
INSTANCE: db2inst1             NODE : 000
HOSTNAME: host2
FUNCTION: DB2 UDB, high avail services, sqlhaExecuteCommandSQO, probe:1063
DATA #1 : String, 13 bytes
host2
DATA #2 : String, 37 bytes
/home/db2/db2inst1/sqllib/adm/db2rocm
DATA #3 : String, 27 bytes
1 DB2 db2inst1 0 GETNETWORK
DATA #4 : String, 8 bytes
db2inst1
DATA #5 : String, 8 bytes
db2inst1
DATA #6 : String, 8 bytes
db2inst1
DATA #7 : unsigned integer, 4 bytes
60000173
DATA #8 : Boolean, 1 bytes
false
DATA #9 : SQLHA Remote Command Output, PD_TYPE_SQLHA_COMMAND_RESPONSE, 3508 bytes
commandResponse->callRC: 0x00000000
commandResponse->output: --------------------------------------------------------------------------------
Authorized uses only. All activity may be monitored and reported.
--------------------------------------------------------------------------------
Connection closed by xx.xx.xx.xx^M

DATA #10: Hex integer, 4 bytes
0x00000000
DATA #11: Hex integer, 4 bhost2ytes
0x000000FF
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
  [0] 0x0000000000508B42 _Z22sqlhaExecuteCommandSQOPcS_S_S_P22SQLHA_COMMAND_RESPONSE + 0x5D2
  [1] 0x00000000005083A3 sqlhaExecuteCommand + 0x1B3
  [2] 0x00007FC29B82CDC5 /lib64/libpthread.so.0 + 0x7DC5
  [3] 0x00007FC29BF4476D clone + 0x6D

The cause of the failure is due to SSH is not configured properly for instance user.

On host host2, as user db2inst1, verify the following commands work:

ssh host2 date
ssh host1 date

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

UID

ibm11140310