Few Questions with HADR - 1

[deshaipet]

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_HOS T) =tucprod1.tx.vz .com
HADR local service name (HADR_LOCAL_SVC ) =db2inst4h
HADR remote host name (HADR_REMOTE_HO ST) =tucprod2.tx.vz .com
HADR remote service name (HADR_REMOTE_SV C) =db2inst4h
HADR instance name of remote server (HADR_REMOTE_IN ST) =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_HOS T) =tucprod2.tx.vz .com
HADR local service name (HADR_LOCAL_SVC ) =db2inst4h
HADR remote host name (HADR_REMOTE_HO ST) =tucprod1.tx.vz .com
HADR remote service name (HADR_REMOTE_SV C) =db2inst4h
HADR instance name of remote server (HADR_REMOTE_IN ST) =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