Db2 On Premise and Cloud

setup HADR problem with db2 docker image 11.5

  • 1.  setup HADR problem with db2 docker image 11.5

    Posted Fri July 05, 2019 10:58 AM
    Hi,
    I have tried to set up HADR with 2 DB2 containers with the latest db2 docker images 11.5 following the instructions in https://hub.docker.com/r/ibmcom/db2

    1. Start on primary host:

    docker run --name node1 --privileged --ipc=host -p 50000 -p 55000 -e LICENSE=accept -e DB2INST1_PASSWORD=<password> -e HADR_ENABLED=true -e ETCD_ENDPOINT=IP1:PORT1,IP2:PORT2,IP3:PORT3 -v /home/db2server_fs/database:/database -v /nfs/shared:/hadr ibmcom/db2

    1. Start on standby host:

    docker run --name node2 --privileged --ipc=host -p 50000 -p 55000 -e LICENSE=accept -e DB2INST1_PASSWORD=<password> -e HADR_ENABLED=true -e ETCD_ENDPOINT=IP1:PORT1,IP2:PORT2,IP3:PORT3 -v /home/db2server_fs/database:/database -v /nfs/shared:/hadr ibmcom/db2


    I have encountered the following errors during the setup on my 2 nodes (primary, standby) :

    primary node:

    ...

    (*) Waiting for STANDBY to write in /hadr/hadr.cfg...

    (*) Waiting for STANDBY to write in /hadr/hadr.cfg...

    (*) Executing setup_hadr on PRIMARY ...

    (!!!) There was an error while executing setup on PRIMARY ...

    Please check /tmp/setup_hadr.log for more information.

    (!!!) There was a failure during HADR setup...

    (*) Entering Governor Setup...

    (*) Editing sudoers file...


    ...


    I login to the container, and look at the setup_hadr.log, might be related to the redo logging configuration? 


    ++ HADR_MANAGE_UPDATE_SUCCESS='


    ################################################################################

    ###     The manage_hadr command updated database on the the primary node.    ###

    ################################################################################


    '

    ++ HADR_MANAGE_ENABLE_ACR_SUCCESS='


    ################################################################################

    ###        The manage_hadr command configured ACR on the HADR database.      ###

    ################################################################################


    '

    ++ HADR_FAILED_TO_DISABLE_REDUCED_REDO_LOGGING='


    * Unabled to disable reduced redo logging on this node.

    * Using HADR is not supported when reduce redo logging is enabled.

    * Please contact IBM support for help.


    So it ended up that the primary node in failing of setting up hadr with above error, while the standby node is keeping waiting for the first node to complete setup.

    Standby node:

    *) Waiting for the PRIMARY to finish executing setup ...

    (*) Waiting for the PRIMARY to finish executing setup ...


    Please advise what has gone wrong, and if any additional steps needed.  I have login to two containers, db2 is up, but not hadr with the above setup problem. 


    Thanks a lot.





    ------------------------------
    KUI YAN LAU
    ------------------------------