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.

Erwin Hattingh

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

Hi, 
See my tweet thread, I just posted today. You are not the only one ....

https://twitter.com/erwin_hattingh/status/972476276362620930?s=20

https://twitter.com/erwin_hattingh/status/972476279466446848?s=20

https://twitter.com/erwin_hattingh/status/972476281160953856?s=20

 

Have a look at

- http://techblog.gis-ag.info/2017/11/28/update-to-rhel-7-4-breaks-db2-cluster-tsamp-rsct/

- https://developer.ibm.com/answers/questions/406023/tsamp-issues-after-updating-to-red-hat-74.html

 

Solution that seems to work in our case, is indeed creating a symbolic link to the RHEL module.

We have a fresh server installation with DB2 v11.1.2.2

Our RHEL and kernel version:
$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.4 (Maipo)
$ uname -a
Linux xxxx.corp 3.10.0-693.17.1.el7.x86_64 #1 SMP Sun Jan 14 10:36:03 EST 2018 x86_64 x86_64 x86_64 GNU/Linu

Tivoli System Automation for Multiplatforms:
 watchdog]# /usr/sbin/rsct/bin/samversion
rsa41svcs003f 4.1.0.3 Apr 26 2017 11:49:24

Reliable Scalable Cluster Technology:
 watchdog]# /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

 

Erwin Hattingh
Systems Engineer / Db2 DBA

Erwin Hattingh

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

See APAR IJ00283: DMS ACTIVATION BROKEN BY RHEL 7 SOFTDOG CHANGE
( http://www-01.ibm.com/support/docview.wss?crawler=1&uid=isg1IJ00283  , last modified 2018-02-13 )

A change to the delivery of Softdog modules, seen first in
RHEL 7.4 (new) and now also in 7.2 (already supported by
RSCT) causes them to be saved as compressed files, in the
same path as they used to be.

For example, under:
"/usr/lib/modules/(build)/kernel/drivers/watchdog/"
The filename "softdog.ko.xz" will be found instead of
"softdog.ko".

The cthats subsystem does not know about this new naming
scheme (it is searching for "*.ko" files), and is unable
to locate a softdog module it can recognize for use.

This results in the DMS (Dead Man Switch) function not
activating, and critical resources cannot be brought
online in an SAMP cluster (with or without DB2).

A change to the delivery of Softdog modules in RHEL 7.2 and
7.4 results in the module used by cthats for the DMS being
unrecognized.

The new naming scheme will be recognized in RSCT 3.2.2.5
and 3.2.3.1 (older levels will need to request an ifix).

DB2 v11.1.2.2 , installed on RHEL 7.4 , comes with :

Tivoli System Automation for Multiplatforms:

# /usr/sbin/rsct/bin/samversion

rsa41svcs003f 4.1.0.3  Apr 26 2017 11:49:24

 

Reliable Scalable Cluster Technology:

# /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

 

 Erwin Hattingh

Harishkumar .Pathangay

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

hi,

thanks for the very valuable information. sorry for the delay in reply. I am not having 7.4 set up now. as I was using trial software for TSAMP I uninstalled it before 90 days itself. even I deleted the Virtual Red Hat Machine. When I set it up again [not sure though] then I will definitely keep this thread in mind and will refer back here. it is very good to get help from experts. thanks very much for your replies.

thanks again, harish p

Erwin Hattingh

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

Apparently with the latest Db2 11.1.3.3 you will still need the patch for RSCT  to address the issue with RHEL compressing softdog packages.

Erwin Hattingh 

Systems Engineer / Db2 DBA

Erwin Hattingh

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

Latest news, March 21 2018, from IBM Db2 Support / TSA RSCT Support :

Starting with DB2 11.1.3.3 You do not need the efix for APAR IJ00283 (as long as you allow it to install the TSAMP deliverables during installation of Db2)

RSCT Support confirmed that APAR IJ00283 is included in PTF1 for RSCT 3.2.3.

see the updated page (March 21, 2018)   What APARs/Defects are included in each of the efix packages for TSAMP 4.1.0.3 that are provided with DB2? : ==> Db2 11.1.3.3 includes TSA MP 4.1.0.3 efix5

Erwin Hattingh 

Systems Engineer / Db2 DBA