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

RAFAEL de AZCARATE

TSA MP 4.1.0.3 and RHEL 7.4
(in response to Harishkumar .Pathangay)

Hi, I have the same problem for me with RHEL 7.4 and DB2 v11.1 FP2

TSA doesn't work, I really need help on it !!

(it clearly mentions about TSA MP not supported for Ubuntu 16.04) YES

I installed TSA 4.1 on Ubuntu 14.04.5 and it's working properly (fine) on 16.04 it doesn't work at all.

( - so on Ubuntu don't make the upgrade and it will be fine with 14.04.5. and DB2 v11.1)

Rafael

Harishkumar .Pathangay

TSA MP 4.1.0.3 and RHEL 7.4
(in response to RAFAEL de AZCARATE)
I found this out in a bad way.
IBM Software Compatibility Report Tool is saying the following.
https://www.ibm.com/software/reports/compatibility/clarity/softwareReqsForProduct.html



7.4 is not supported for pureScale. I assume TSA is also Cluster Technology only.
So will not get supported.
I am only using for learning purpose. So went and re-installed 7.2 in my VM.
After 60 Days, I will uninstall it any ways.

Thanks,
Harish Pathangay

Sent from Mail for Windows 10

From: RAFAEL de AZCARATE
Sent: 30 November 2017 14:21
To: [login to unmask email]
Subject: [DB2-L] - TSA MP 4.1.0.3 and RHEL 7.4

Hi, I have the same problem for me with RHEL 7.4 and DB2 v11.1 FP2
TSA doesn't work, I really need help on it !!
(it clearly mentions about TSA MP not supported for Ubuntu 16.04) YES
I installed TSA 4.1 on Ubuntu 14.04.5 and it's working properly (fine) on 16.04 it doesn't work at all.
( - so on Ubuntu don't make the upgrade and it will be fine with 14.04.5. and DB2 v11.1)
Rafael


Site Links: View post online   View mailing list online   Start new thread via email   Unsubscribe from this mailing list   Manage your subscription  

This email has been sent to: [login to unmask email]
Setup a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU
ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See
http://www.ESAIGroup.com/idug

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2


Attachments

  • 2E7DEE8DB3994FCFA62B59450B26BF20.png (54.2k)
  • C5611336F54E4CC19922B85ED3E4C241.png (<1k)

Rui Chen

RE: TSA MP 4.1.0.3 and RHEL 7.4
(in response to Harishkumar .Pathangay)

these two threads may provide some clues link-1 and link-2 if you saw similar message in db2diag and syslog. But i haven't tried out yet...

 

One thing we did try is that this fix won't work with AmazonLinux 4.9.62-21.56.amzn1.x86_64, due to missing softdog module...... 

Edited By:
Rui Chen[Organization Members] @ Dec 15, 2017 - 05:16 PM (America/Eastern)

Harishkumar .Pathangay

RE: TSA MP 4.1.0.3 and RHEL 7.4
(in response to Rui Chen)

thanks to the information very helpful.

yes, I currently do not have environment to test that. I removed all RHEL 7.4 VM's.

so definitely thanks for the information. will take time to test that out.