Results 1 to 7 of 7

Thread: tsa hadr vip

  1. #1
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,545
    Provided Answers: 11

    Unanswered: tsa hadr vip

    we have db2 v11 on linux with hadr and tsa and vip for this db in same rg
    now we have a situation where we could takeover the db by takeover command - the standby becomes primary and primary becomes standby : ok
    but as the old primary (now standby) is in problem state for tsa - the vip does not follow the db
    the problem that users can not connect to new primary database
    does anyone knows any command - any possibility to force this vip to move to the same node as the database
    we tried all kind of commands of tsa (like chrg ..unlock - resetrsrc) but not able to get the vip online on other node
    if any possibility for this in tsa or outside tsa, it would be nice to share this with me...
    anyhow, many thanks for all update
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  2. #2
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    304
    Provided Answers: 45
    What's the output of the following?
    Code:
    lssam -s "Name like 'db2#_myinstance%'" -noequ -nocolor
    myinstance is your instance name.


    BTW,
    It's quite unusual to see the "the vip does not follow the db" situation, since the ServiceIP resource must be in the same resource group as the Application resource of the HADR-enabled database.
    Code:
    Online IBM.ResourceGroup:db2_db2hadr2_db2hadr2_SAMPLE-rg Nominal=Online
            |- Online IBM.Application:db2_db2hadr2_db2hadr2_SAMPLE-rs
                    |- Online IBM.Application:db2_db2hadr2_db2hadr2_SAMPLE-rs:ps-lnx1
                    '- Offline IBM.Application:db2_db2hadr2_db2hadr2_SAMPLE-rs:ps-lnx2
            '- Online IBM.ServiceIP:db2ip_IP-rs
                    |- Online IBM.ServiceIP:db2ip_IP-rs:ps-lnx1
                    '- Offline IBM.ServiceIP:db2ip_IP-rs:ps-lnx2
    Regards,
    Mark.

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,545
    Provided Answers: 11
    thanks for the update
    yes, the vip is in the same rg as the database
    as there is a problem with node/instance/db (old primary) tsa can not move the db rs and does not handle the vip
    I am not logon at the customer for the moment - but still have the lssam output
    [root@luechdb131 ~]# lssam

    Pending online IBM.ResourceGroup:CDC_group Control=MemberInProblemState
    Nominal=Online

    '- Offline IBM.Application:CDC_daemon Control=MemberInProblemState

    |- Failed offline IBM.Application:CDC_daemon:luechdb130
    Node=Offline

    '- Offline IBM.Application:CDC_daemon:luechdb131

    Offline IBM.ResourceGroup:db2_dbllua1_dbllua1_IEEINT-rg
    Request=Move(Online:O) Binding=Sacrificed Nominal=Online

    |- Offline IBM.Application:db2_dbllua1_dbllua1_IEEINT-rs
    Control=MemberInProblemState

    |- Failed offline
    IBM.Application:db2_dbllua1_dbllua1_IEEINT-rs:luechdb130 Node=Offline

    '- Offline
    IBM.Application:db2_dbllua1_dbllua1_IEEINT-rs:luechdb131

    '- Offline IBM.ServiceIP:db2ip_10_16_0_136-rs
    Control=MemberInProblemState

    |- Failed offline
    IBM.ServiceIP:db2ip_10_16_0_136-rs:luechdb130 Node=Offline

    '- Offline IBM.ServiceIP:db2ip_10_16_0_136-rs:luechdb131

    Online IBM.ResourceGroup:db2_dbllua1_dbllua1_IEELOC-rg
    Request=Move(Online:O) Control=MemberInProblemState Nominal=Online

    |- Online IBM.Application:db2_dbllua1_dbllua1_IEELOC-rs
    Control=MemberInProblemState

    |- Failed offline
    IBM.Application:db2_dbllua1_dbllua1_IEELOC-rs:luechdb130 Node=Offline

    '- Online
    IBM.Application:db2_dbllua1_dbllua1_IEELOC-rs:luechdb131

    '- Online IBM.ServiceIP:db2ip_10_16_0_132-rs
    Control=MemberInProblemState

    |- Failed offline
    IBM.ServiceIP:db2ip_10_16_0_132-rs:luechdb130 Node=Offline

    '- Online IBM.ServiceIP:db2ip_10_16_0_132-rs:luechdb131

    Failed offline IBM.ResourceGroup:db2_dbllua1_luechdb130_0-rg Nominal=Offline

    '- Failed offline IBM.Application:db2_dbllua1_luechdb130_0-rs

    '- Failed offline
    IBM.Application:db2_dbllua1_luechdb130_0-rs:luechdb130 Node=Offline

    Online IBM.ResourceGroup:db2_dbllua1_luechdb131_0-rg Nominal=Online

    '- Online IBM.Application:db2_dbllua1_luechdb131_0-rs

    '- Online
    IBM.Application:db2_dbllua1_luechdb131_0-rs:luechdb131

    Online IBM.Equivalency:db2_dbllua1_dbllua1_IEEINT-rg_group-equ

    |- Offline IBM.PeerNode:luechdb130:luechdb130 Node=Offline

    '- Online IBM.PeerNode:luechdb131:luechdb131

    Online IBM.Equivalency:db2_dbllua1_dbllua1_IEELOC-rg_group-equ

    |- Offline IBM.PeerNode:luechdb130:luechdb130 Node=Offline

    '- Online IBM.PeerNode:luechdb131:luechdb131

    Online IBM.Equivalency:db2_dbllua1_luechdb130_0-rg_group-equ

    '- Offline IBM.PeerNode:luechdb130:luechdb130 Node=Offline

    Online IBM.Equivalency:db2_dbllua1_luechdb131_0-rg_group-equ

    '- Online IBM.PeerNode:luechdb131:luechdb131

    Online IBM.Equivalency:db2_public_network_0

    |- Offline IBM.NetworkInterface:ens192:luechdb130 Node=Offline

    '- Online IBM.NetworkInterface:ens192:luechdb131
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  4. #4
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    304
    Provided Answers: 45
    Did I get it right that you want to bring the database IEEINT online?
    According to TSA you have:
    Code:
    Offline IBM.ResourceGroup:db2_dbllua1_dbllua1_IEEINT-rg Request=Move(Online:O) Binding=Sacrificed Nominal=Online
      |- Offline IBM.Application:db2_dbllua1_dbllua1_IEEINT-rs Control=MemberInProblemState
        |- Failed offline IBM.Application:db2_dbllua1_dbllua1_IEEINT-rs:luechdb130 Node=Offline
        '- Offline IBM.Application:db2_dbllua1_dbllua1_IEEINT-rs:luechdb131
    
      '- Offline IBM.ServiceIP:db2ip_10_16_0_136-rs Control=MemberInProblemState
        |- Failed offline IBM.ServiceIP:db2ip_10_16_0_136-rs:luechdb130 Node=Offline
        '- Offline IBM.ServiceIP:db2ip_10_16_0_136-rs:luechdb131
    This means (at least from the TSA point of view), that the database IEEINT is not active on luechdb131, which is your new primary server now (where IEELOC is active).
    First of all you should check the role of IEEINT on luechdb131.
    Is this database active there?
    What's the HADR state?
    If it's not active, what's the HADR role of the database according to the db parameter?
    On luechdb131:
    Code:
    su - dbllua1 -c "db2pd -hadr -db IEEINT | grep -E 'ROLE|STATE'"
    su - dbllua1 -c "db2 get db cfg for IEEINT | grep -i 'role'"
    Last edited by mark.bb; 11-28-17 at 09:35.
    Regards,
    Mark.

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,545
    Provided Answers: 11
    thanks for the update
    as we executed the takeover command on db131 : this was correct - verified with db2pd : primary - disconnected
    the database became primary on db131 ans usable locally
    the problem is that the vip stays on db130 and new primary on db131 can not be accessed - as tsa has problem with db on db130 and does not continue with move of vip
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  6. #6
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    304
    Provided Answers: 45
    TSA on db131 believes, that luechdb130 is down.
    Code:
    Online IBM.Equivalency:db2_dbllua1_luechdb130_0-rg_group-equ
      '- Offline IBM.PeerNode:luechdb130:luechdb130 Node=Offline
    It's not good, you should investigate this.
    Is db130 accessible (I presume yes, since you said that VIP 10.16.0.136 is online there)?
    What's the lssam output there?
    Regards,
    Mark.

  7. #7
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    304
    Provided Answers: 45
    The TSA command to bring the resource online on the specific host is:
    Code:
    startrsrc -s "Name='db2ip_10_16_0_136-rs' & NodeNameList='luechdb131'" IBM.ServiceIP
    but you shouldn't run it until you investigate why db130 is online is holding the VIP 10.16.0.136, but db131 considers, that db130 is offline.
    Otherwise it's better to move whole TSA cluster to the manual mode with 'samctrl -M T' (or even stop the domain with -f on both hosts if the latter command doesn't work) to suppress any possible automated actions, kill the VIP on db130:
    Code:
    ifconfig ens192:xxx del 10.16.0.136
    and bring it online on db131:
    Code:
    ifconfig ens192:xxx 10.16.0.136 netmask <netmask>
    Regards,
    Mark.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •