yes, I have those directories created. I have setup nfs server for hadr directory, and have etcd setup as well.
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
Original Message:
Sent: Tue July 09, 2019 01:13 PM
From: IRINA DELIDJAKOVA
Subject: hadr setup problem with db2 docker image 11.5
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
Original Message:
Sent: Thu July 04, 2019 03:03 PM
From: KUI YAN LAU
Subject: hadr setup problem with db2 docker image 11.5
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