TSA MP 4.1.0.3 in RHEL 7.4 not working? Help Pls.

Harishkumar .Pathangay

TSA MP 4.1.0.3 in RHEL 7.4 not working? Help Pls.

Hi,

I have RHEL 7.4 in 2 VM's. db2 V11.1GA Server Trial is installed, configured for HADR. All is well.

installed TSA also.

[[login to unmask email] ~]# samversion
rsa41svcs003b 4.1.0.3  Apr 13 2016 09:25:51
[[login to unmask email] ~]#
[[login to unmask email] ~]# /usr/sbin/rsct/install/bin/ctversion -b
RSCT_Build_Name=roots002a 3.2.1.2 RSCT_Build_Time=16097.22:05:47 RSCT_Build_Context=amd64_linux_2

 

All up and running.

But db2haicu is giving error when adding database in Primary to Peer Domain.

Any Help Pls.

Thanks,Harish Pathangay

 

ERROR in db2diag.log:

2017-11-08-18.24.25.287890+330 I815164E424 LEVEL: Warning
PID : 6510 TID : 140377229903744 PROC : db2havend (db2ha)
INSTANCE: db2inst1 NODE : 000
HOSTNAME: rhel-pc
FUNCTION: DB2 UDB, high avail services, db2haAddResource, probe:12489
DATA #1 : <preformatted>
Error adding resource db2_db2inst1_db2inst1_MUGGY-rs to group db2_db2inst1_db2inst1_MUGGY-rg, resource handle is NOT valid

2017-11-08-18.24.26.541326+330 E815589E646 LEVEL: Error
PID : 6442 TID : 140475885983616 PROC : db2haicu
INSTANCE: db2inst1 NODE : 000
HOSTNAME: rhel-pc
FUNCTION: DB2 UDB, high avail services, sqlhaAddResource, probe:1904
MESSAGE : ECF=0x90000543=-1879046845=ECF_SQLHA_CREATE_RES_FAILED
Create resource failed
DATA #1 : String, 60 bytes
libsqlha: sqlhaAddResource() call error from wrapper library
DATA #2 : String, 30 bytes
db2_db2inst1_db2inst1_MUGGY-rs
DATA #3 : String, 70 bytes
Line # : 23686---2610-350 The specified resource handle is incorrect.
DATA #4 : signed integer, 4 bytes
196652

2017-11-08-18.24.26.542417+330 E816236E370 LEVEL: Error
PID : 6442 TID : 140475885983616 PROC : db2haicu
INSTANCE: db2inst1 NODE : 000
HOSTNAME: rhel-pc
FUNCTION: DB2 UDB, high avail services, sqlhaCreateClusterObject, probe:2155
RETCODE : ECF=0x90000543=-1879046845=ECF_SQLHA_CREATE_RES_FAILED
Create resource failed

2017-11-08-18.24.26.569279+330 E816607E594 LEVEL: Error
PID : 6442 TID : 140475885983616 PROC : db2haicu
INSTANCE: db2inst1 NODE : 000
HOSTNAME: rhel-pc
FUNCTION: DB2 UDB, high avail services, sqlhaUICreateHADR, probe:7674
MESSAGE : ECF=0x90000543=-1879046845=ECF_SQLHA_CREATE_RES_FAILED
Create resource failed
DATA #1 : String, 31 bytes
Could not create HADR Resource.
DATA #2 : String, 8 bytes
db2inst1
DATA #3 : String, 8 bytes
db2inst1
DATA #4 : String, 7 bytes
rhel-pc
DATA #5 : String, 9 bytes
rhel-vbox
DATA #6 : String, 5 bytes
MUGGY

2017-11-08-18.24.26.902887+330 E817202E366 LEVEL: Error
PID : 6442 TID : 140475885983616 PROC : db2haicu
INSTANCE: db2inst1 NODE : 000
HOSTNAME: rhel-pc
FUNCTION: DB2 UDB, high avail services, sqlhaUIConfigureHADR, probe:2095
MESSAGE : ECF=0x90000543=-1879046845=ECF_SQLHA_CREATE_RES_FAILED
Create resource failed

Harishkumar .Pathangay

RE: TSA MP 4.1.0.3 in RHEL 7.4 not working? Help Pls.
(in response to Harishkumar .Pathangay)

TSA MP with DB2 10.5 on Ubuntu 16.04 works good.

TSA MP with DB2 10.5 on RHEL 7.4 not working.

TSA MP with DB2 11.1 on RHEL 7.4 not working.

What i am missing?

The errors are all same. As posted in previous message.

 

Harishkumar .Pathangay

RE: TSA MP 4.1.0.3 in RHEL 7.4 not working? Help Pls.
(in response to Harishkumar .Pathangay)

Any Help Pls?

It is not working in RHEL 7.4 with DB2 11.1 Mod 1 Fix Pack 1 too.

Same error in db2diag.log.

Please Any Help? Why it is not working?

I have even setup password less root ssh between both servers.

thanks,

harish pathangay  

Harishkumar .Pathangay

RE: TSA MP 4.1.0.3 in RHEL 7.4 not working? Help Pls.
(in response to Harishkumar .Pathangay)

TSA MP 4.1.0.3 works in RHEL 7.2

Some thing is wrong in 7.4? Do not know what is happening looking at the error.

Harishkumar .Pathangay

RE: TSA MP 4.1.0.3 in RHEL 7.4 not working? Help Pls.
(in response to Harishkumar .Pathangay)

I even looked at software compatibility report.

it clearly mentions about TSA MP not supported for Ubuntu 16.04

but it does not mention any TSA MP support details for RHEL 7.4 

if pure Scale is not supported can we safely assume that TSA will also be not supported.

thanks,

harish pathagay