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

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.

Thanks a lot .
Pandit