Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2008
    Posts
    76

    Thumbs up Unanswered: Few Questions on HADR -1

    Hi -

    We have primary and standby databases on different servers.

    Here is my /etc/service entry for HADR pair :

    On Primary :

    "vi /etc/services

    db2inst4c 3706/tcp # DB2 UDB INSTANCE
    db2inst4h 51000/tcp # DB2 UDB HADR inst4"

    On Standby :

    "vi /etc/services

    db2inst4c 3706/tcp # DB2 UDB INSTANCE
    db2inst4h 51000/tcp # DB2 UDB HADR inst4"

    ------

    HADR database config params on primary :

    Primary Database HADR Config param :

    HADR database role = STANDARD
    HADR local host name (HADR_LOCAL_HOST) =tucprod1.tx.vz.com
    HADR local service name (HADR_LOCAL_SVC) =db2inst4h
    HADR remote host name (HADR_REMOTE_HOST) =tucprod2.tx.vz.com
    HADR remote service name (HADR_REMOTE_SVC) =db2inst4h
    HADR instance name of remote server (HADR_REMOTE_INST) =db2inst4c
    HADR timeout value (HADR_TIMEOUT) = 120
    HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC

    -----

    Standby Database HADR config param :

    HADR database role = STANDARD
    HADR local host name (HADR_LOCAL_HOST) =tucprod2.tx.vz.com
    HADR local service name (HADR_LOCAL_SVC) =db2inst4h
    HADR remote host name (HADR_REMOTE_HOST) =tucprod1.tx.vz.com
    HADR remote service name (HADR_REMOTE_SVC) =db2inst4h
    HADR instance name of remote server (HADR_REMOTE_INST) =db2inst4c
    HADR timeout value (HADR_TIMEOUT) = 120
    HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC


    Questions :

    1) How many ports should I use for an HADR pair one or two. Right now Iam planning to use only one.

    2) Can the same service name for HADR_LOCAL_SVC and HADR_REMOTE_SVC on both primary and standy databases ?

    3) Are the above mentioned config params set correctly. Please let me know if any of them are incorrect.



    Thanks
    Pandit

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You should have two HADR ports on each server, and they are flip-flopped, so that HADR_LOCAL_SVC on the primary is the same as the HADR_REMOTE_SVC on the standby.

    The HADR_TIMEOUT of 120 is high for NEARSYNC. I usually use 30 seconds, but you could go a little higher if there is some reason to, but probably not past 60 seconds.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2008
    Posts
    76

    Thanks a lot Marcus

    Thanks a lot .
    Pandit

Posting Permissions

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