IC SunsetThe developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this community and its apps will no longer be available. More details available on our FAQ.
Topic
  • No replies
jpkenken
jpkenken
1 Post

Pinned topic TSA4.1 db2 cluster set up of two nodes using db2haicu.

‏2017-10-17T06:16:00Z | db2 db2haicu tsamp

I installed TSA4.1, and tried configuring High Availability for database using db2haicu tool. In the process I used two nodes, connected public net eth0 , configured network quorum and provided a virtual IP for providing single interface to any one of the online database along with automatic client reroute. db2haicu executed successfully.but db2diag.log have error.
and lssam is here

#lssam
Pending offline IBM.ResourceGroup:db2_db2inst1_0-rg Binding=Sacrificial Nominal=Online
        |- Pending online IBM.Application:db2_db2inst1_0-rs Binding=Sacrificial
                |- Pending online IBM.Application:db2_db2inst1_0-rs:node1
                '- Offline IBM.Application:db2_db2inst1_0-rs:node2
        '- Offline IBM.ServiceIP:db2ip_serviceip-rs Binding=Sacrificial
                |- Failed offline IBM.ServiceIP:db2ip_serviceip-rs:node1
                '- Offline IBM.ServiceIP:db2ip_serviceip-rs:node2
Online IBM.Equivalency:db2_db2inst1_0-rg_group-equ
        |- Online IBM.PeerNode:node1:node1
        '- Online IBM.PeerNode:node2:node2
Online IBM.Equivalency:db2_public_network_0
        |- Online IBM.NetworkInterface:eth0:node1
        '- Online IBM.NetworkInterface:eth0:node2

i have two problem
1, IBM.Application:db2_db2inst1_0-rs is Binding=Sacrifical
2, IBM.ServiceIP:db2ip_serviceip-rs Binding=Sacrificial allways offine
2-1, ifconfig serviceIP isnot registered in ipconfig

I do not know what is the problem, where to investigate, and what is the correct answer.

I think there is a problem with the setting of the service IP and the shared disk.
mount point is /share.
instance is /share/db2/db2inst1/sqllib

db2diag.log(summary)
level    proc        message    resource
ERROR    db2haicu    ECF_SQLHA_CREATE_RES_FAILED    db2mnt-share-rs
ERROR    db2haicu    ECF_SQLHA_CREATE_RES_FAILED    db2mnt-share-rs
ERROR    db2havend (db2ha)    PD_TYPE_DB2HA_CLUSTER_ERROR_CODE    db2mnt-share-rs
ERROR    db2haicu    ECF_SQLHA_OBJECT_DOES_NOT_EXIST    db2mnt-share-rs
ERROR    db2haicu    ECF_SQLHA_OBJECT_DOES_NOT_EXIST    db2mnt-share-rs
ERROR    db2haicu    ECF_SQLHA_OBJECT_DOES_NOT_EXIST    db2mnt-share-rs
ERROR    db2haicu    ECF_SQLHA_CREATE_RES_FAILED    
ERROR    db2haicu    ECF_SQLHA_CREATE_RES_FAILED    
ERROR    db2haicu    ECF_SQLHA_CREATE_RES_FAILED    
ERROR    db2haicu    ECF_SQLHA_CREATE_RES_FAILED    
ERROR    db2haicu    ECF_SQLHA_CREATE_RES_FAILED    

ken.
thank you for your help and support.