IBM Support

How can I check if TSA is working with no problem?

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.

 

[{"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

ibm13286377