Db2

 View Only
  • 1.  hadr setup problem with db2 docker image 11.5

    Posted Fri July 05, 2019 10:59 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

    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

    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
    ------------------------------

    #Db2


  • 2.  RE: hadr setup problem with db2 docker image 11.5

    Posted Tue July 09, 2019 01:14 PM

    Hi  ​@KUI YAN LAU There will be more information in the /tmp/setup_hadr.log log file - you need to scroll through it. The contents you posted are just informational messages, not the actual error.

    However, when I look at your docker run commands, they contain placeholders in there that are not actual values, for example:
    ```
    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

    ```

    - Do you have these directories created? i.e. /nfs/shared and /home/db2server_fs/database ? Have you specified an actual password in DB2INST1_PASSWORD ? Can you verify that these are the actual commands?



    ------------------------------
    IRINA DELIDJAKOVA
    ------------------------------



  • 3.  RE: hadr setup problem with db2 docker image 11.5

    Posted Thu July 11, 2019 03:15 PM
    yes, I have those directories created. I have setup nfs server for hadr directory,  and have etcd setup as well. 

    docker command for my node1, and similarly for my node2:
    docker run --name node1 --privileged --ipc=host -p 50000 -p 55000 -e LICENSE=accept -e DB2INST1_PASSWORD=db2admin -e HADR_ENABLED=true -e ETCD_ENDPOINT=9.30.x.x:5555 -v ~/db2_1/database:/database -v ~/hadr:/hadr ibmcom/db2

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