Technical Blog Post
Abstract
How can I check if TSA is working with no problem?
Body
I have configured TSA+HDAR environment by db2haicu. To check if HADR is working I can use "db2pd -db <DBname> -hadr" command, but how can I check if TSAMP is working with no problem?
The most straightforward method is through "lssam" command. Here is an example of "lssam" output of a TSAMP managed HADR:
[root@clnode1 ~]# lssam
Online IBM.ResourceGroup:db2_db2inst1_clnode1_0-rg Nominal=Online
'- Online IBM.Application:db2_db2inst1_clnode1_0-rs
'- Online IBM.Application:db2_db2inst1_clnode1_0-rs:clnode1
Online IBM.ResourceGroup:db2_db2inst1_clnode2_0-rg Nominal=Online
'- Online IBM.Application:db2_db2inst1_clnode2_0-rs
'- Online IBM.Application:db2_db2inst1_clnode2_0-rs:clnode2
Online IBM.ResourceGroup:db2_db2inst1_db2inst1_TESTDB-rg Nominal=Online
|- Online IBM.Application:db2_db2inst1_db2inst1_TESTDB-rs
|- Online IBM.Application:db2_db2inst1_db2inst1_TESTDB-rs:clnode1
'- Offline IBM.Application:db2_db2inst1_db2inst1_TESTDB-rs:clnode2
'- Online IBM.ServiceIP:db2ip_192_168_0_222-rs
|- Online IBM.ServiceIP:db2ip_192_168_0_222-rs:clnode1
'- Offline IBM.ServiceIP:db2ip_192_168_0_222-rs:clnode2
Online IBM.Equivalency:db2_db2inst1_clnode1_0-rg_group-equ
'- Online IBM.PeerNode:clnode1:clnode1
Online IBM.Equivalency:db2_db2inst1_clnode2_0-rg_group-equ
'- Online IBM.PeerNode:clnode2:clnode2
Online IBM.Equivalency:db2_db2inst1_db2inst1_TESTDB-rg_group-equ
|- Online IBM.PeerNode:clnode1:clnode1
'- Online IBM.PeerNode:clnode2:clnode2
Online IBM.Equivalency:db2_public_network_0
|- Online IBM.NetworkInterface:eth1:clnode2
'- Online IBM.NetworkInterface:eth1:clnode1
[root@clnode1 ~]#
There are a few things to check:
(1) Individual nodes are ONLINE =>
Online IBM.ResourceGroup:db2_db2inst1_clnode1_0-rg Nominal=Online
'- Online IBM.Application:db2_db2inst1_clnode1_0-rs
'- Online IBM.Application:db2_db2inst1_clnode1_0-rs:clnode1
Online IBM.ResourceGroup:db2_db2inst1_clnode2_0-rg Nominal=Online
'- Online IBM.Application:db2_db2inst1_clnode2_0-rs
'- Online IBM.Application:db2_db2inst1_clnode2_0-rs:clnode2
(2) The database instance is ONLINE =>
Online IBM.ResourceGroup:db2_db2inst1_db2inst1_TESTDB-rg Nominal=Online
|- Online IBM.Application:db2_db2inst1_db2inst1_TESTDB-rs
|- Online IBM.Application:db2_db2inst1_db2inst1_TESTDB-rs:clnode1
'- Offline IBM.Application:db2_db2inst1_db2inst1_TESTDB-rs:clnode2
'- Online IBM.ServiceIP:db2ip_192_168_0_222-rs
|- Online IBM.ServiceIP:db2ip_192_168_0_222-rs:clnode1
'- Offline IBM.ServiceIP:db2ip_192_168_0_222-rs:clnode2
(a) From the above, the primary HADR node will be the one ONLINE while the standby node is the one OFFLINE =>
|- Online IBM.Application:db2_db2inst1_db2inst1_TESTDB-rs
|- Online IBM.Application:db2_db2inst1_db2inst1_TESTDB-rs:clnode1
'- Offline IBM.Application:db2_db2inst1_db2inst1_TESTDB-rs:clnode2
(b) If ServiceIP is configured, it should be ONLINE together with the primary node =>
'- Online IBM.ServiceIP:db2ip_192_168_0_222-rs
|- Online IBM.ServiceIP:db2ip_192_168_0_222-rs:clnode1
'- Offline IBM.ServiceIP:db2ip_192_168_0_222-rs:clnode2
(3) The equivalencies should not be wrong if the environment is configured through db2haicu, so there is no need to worry about that.
UID
ibm13286377