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