View Only
  • 1.  HDR to Standard

    Posted Tue April 16, 2024 01:16 AM


    We have an HA array with primary, HDR, RSS

    We'd like to disconnect the HDR and make it standard

    But depends on this doc the condition is:

    Database server type can be changed from secondary to standard only if HDR is turned off on the secondary database server. HDR is turned off when either the Primary database server is down or Primary database server is converted to standard mode.

    But we don't want to turn the primary off because this is the prod environment and neither standard because of the RSS connected.

    So, is there any other way to change the HDR from secondary to standard?


    Samuel To

  • 2.  RE: HDR to Standard

    Posted Tue April 16, 2024 02:03 AM
    Edited by Doug Lawry Tue April 16, 2024 02:03 AM

    Hi Samuel.

    Others will correct me if there is anything missing, but I believe you can run "onmode -d standard" on primary then HDR without RSS being affected. That command relates only to the HDR state and not RSS.

    Doug Lawry
    Oninit Consulting

  • 3.  RE: HDR to Standard

    IBM Champion
    Posted Tue April 16, 2024 04:30 AM
    The manual says you should shutdown the primary server before putting the secondary to standard mode,
    because having two standard servers will break the consistency of the HDR.
    You cannot convert a standard server to secondary again if it has been online, that can only be done 
    if the server has not touched any data since the connection was interrupted.

    When you are planning to not shutting down the primary, you should convert it to standard mode as well, 
    which will disconnect the secondary, maybe you will need to re-attach the RSS, but I don't think so.

    This would result in having two standard servers (one backed up with the RSS peer), which are not
    connected to each other any more.
    If that is the plan (for whatever reason), this should work, but data will be different as the old primary is still 
    You might consider setting up a new secondary server on a different hardware or converting the RSS
    to a secondary in order to have redundancy as before.
    When your intention is to start with the old secondary as a base for ER, this should be doable as well.


  • 4.  RE: HDR to Standard

    IBM Champion
    Posted Tue April 16, 2024 08:42 AM


    It is safe to take the primary to STANDARD mode so that you can decommission the HDR secondary. The RSS secondary does not need the primary to be in PRIMARY mode. RSS can work with a standard mode primary just fine.


    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.

  • 5.  RE: HDR to Standard

    Posted Sun April 21, 2024 12:12 AM

    Hello everyone

    and thanks for your help

    Samuel To