470,868 Members | 1,946 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,868 developers. It's quick & easy.

Few Questions with HADR - 1

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
Jun 28 '09 #1
0 2220

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by shindle | last post: by
3 posts views Thread by bwmiller16 | last post: by
7 posts views Thread by Mark A | last post: by
reply views Thread by Marc | last post: by
4 posts views Thread by Joachim Klassen | last post: by
16 posts views Thread by gumby | last post: by
6 posts views Thread by RayRay | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.