Skip to Content
0
Former Member
Oct 11, 2013 at 07:17 AM

db2 HADR start problem

549 Views

Dear gurus,
I want ask you a help in DB2 HADR setup.
I have 2 MS Win 2008 Entr ST2 servers, with 9.1 DB2. (x64)
I did full offline backup on primary server, go to standby and made a
DB copy from backup.
I added to \etc\services
db2c_db2inst1 = 50000/tcp
DB2_HADR_1 = 55001/tcp
DB2_HADR_2 = 55002/tcp
Set parameters on servers:
Primary
db2 UPDATE DB CFG FOR QAS USING HADR_LOCAL_HOST 172.21.1.52
db2 UPDATE DB CFG FOR QAS USING HADR_LOCAL_SVC DB2_HADR_1
db2 UPDATE DB CFG FOR QAS USING HADR_REMOTE_HOST 172.21.1.54
db2 UPDATE DB CFG FOR QAS USING HADR_REMOTE_SVC DB2_HADR_3
db2 UPDATE DB CFG FOR QAS USING HADR_REMOTE_INST db2inst1
db2 UPDATE DB CFG FOR QAS USING HADR_SYNCMODE NEARSYNC
db2 UPDATE DB CFG FOR QAS USING HADR_TIMEOUT 120
Standby
db2 UPDATE DB CFG FOR QAS USING HADR_LOCAL_HOST 172.21.1.54
db2 UPDATE DB CFG FOR QAS USING HADR_LOCAL_SVC DB2_HADR_3
db2 UPDATE DB CFG FOR QAS USING HADR_REMOTE_HOST 172.21.1.52
db2 UPDATE DB CFG FOR QAS USING HADR_REMOTE_SVC DB2_HADR_1
db2 UPDATE DB CFG FOR QAS USING HADR_REMOTE_INST db2inst1
db2 UPDATE DB CFG FOR QAS USING HADR_SYNCMODE NEARSYNC
db2 UPDATE DB CFG FOR QAS USING HADR_TIMEOUT 120

Than I started HADR on standbydb without error with command
db2 START HADR ON DATABASE QAS AS STANDBY
But when I tried to start HADR on Primary server I had an error.

2013-10-07-14.25.16.381000+180 I129613726F412 LEVEL: Error
PID : 3860 TID : 4800 PROC : db2syscs.exe
INSTANCE: DB2QAS NODE : 000
FUNCTION: DB2 UDB, High Availability Disaster Recovery,
hdrInitSocketHandle, probe:20190
RETCODE : ZRC=0x87800143=-2021654205=HDR_ZRC_CONFIG_REMOTE_SVC
"HADR_REMOTE_SVC configuration parameter is an invalid
service name"

CFG parameters from primary DB

HADR database role = STANDARD
HADR local host name (HADR_LOCAL_HOST) = 172.21.1.52
HADR local service name (HADR_LOCAL_SVC) = DB2_HADR_1
HADR remote host name (HADR_REMOTE_HOST) = 172.21.1.54
HADR remote service name (HADR_REMOTE_SVC) = DB2_HADR_3
HADR instance name of remote server (HADR_REMOTE_INST) = db2inst1
HADR timeout value (HADR_TIMEOUT) = 120
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC

First log archive method (LOGARCHMETH1) = DISK:E:\db2
\archlogs\

Options for logarchmeth1 (LOGARCHOPT1) =
Second log archive method (LOGARCHMETH2) =
VENDOR:C:\PROGRA~1\Ti
voli\TSM\tdp_r3\db264\tdpdb2.dll
Options for logarchmeth2 (LOGARCHOPT2) = D:\db2
\db2qas\tdp_r3\
vendor.env

I've been stack on this error...
Can you help me ???