求教。V9.5 hadr配置。
在V9.5下配置hadr,当HADR_LOCAL_HOST和HADR_REMOTE_HOST使用ip时,能正常工作。当使用hostname时,在启动完standy后,primary启动时报出:SQL1768N Unable to start HADR. Reason code = "7".
primary 的dialog日志:
2013-07-17-09.20.06.588084+480 E820799310E468 LEVEL: Event
PID : 13824 TID : 47237484767552PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : IEONLDB
APPHDL : 0-234 APPID: *LOCAL.db2inst1.130717012007
AUTHID : DB2INST1
EDUID : 421 EDUNAME: db2agent (IEONLDB) 0
FUNCTION: DB2 UDB, base sys utilities, sqeDBMgr::StartUsingLocalDatabase, probe:13
START : Received START HADR command.
2013-07-17-09.20.07.483812+480 I820799779E471 LEVEL: Warning
PID : 13824 TID : 47237484767552PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : IEONLDB
APPHDL : 0-234 APPID: *LOCAL.db2inst1.130717012007
AUTHID : DB2INST1
EDUID : 421 EDUNAME: db2agent (IEONLDB) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduStartup, probe:21151
MESSAGE : Info: HADR Startup has begun.
2013-07-17-09.20.07.484172+480 E820800251E364 LEVEL: Event
PID : 13824 TID : 47237451213120PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 502 EDUNAME: db2hadrp (IEONLDB) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetHdrState, probe:10000
CHANGE : HADR state set to None (was None)
2013-07-17-09.20.08.337409+480 I820800616E392 LEVEL: Warning
PID : 13824 TID : 47237451213120PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 502 EDUNAME: db2hadrp (IEONLDB) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrResolveHostNamesToIp, probe:20100
MESSAGE : HADR_LOCAL_HOST db144.lthj.com mapped to 127.0.0.1
2013-07-17-09.20.08.337569+480 I820801009E398 LEVEL: Warning
PID : 13824 TID : 47237451213120PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 502 EDUNAME: db2hadrp (IEONLDB) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrResolveHostNamesToIp, probe:20110
MESSAGE : HADR_REMOTE_HOST db164.lthj.com mapped to 192.168.30.164
2013-07-17-09.20.08.337639+480 I820801408E353 LEVEL: Warning
PID : 13824 TID : 47237451213120PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 502 EDUNAME: db2hadrp (IEONLDB) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrResolveHosts, probe:20157
MESSAGE : HADR is using IPv4.
2013-07-17-09.20.08.340592+480 E820801762E366 LEVEL: Event
PID : 13824 TID : 47237451213120PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 502 EDUNAME: db2hadrp (IEONLDB) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetHdrState, probe:10000
CHANGE : HADR state set to P-Boot (was None)
2013-07-17-09.20.08.341106+480 I820802129E348 LEVEL: Warning
PID : 13824 TID : 47237451213120PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 502 EDUNAME: db2hadrp (IEONLDB) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduP, probe:20301
MESSAGE : Info: Primary Started.
2013-07-17-09.20.08.341246+480 I820802478E396 LEVEL: Warning
PID : 13824 TID : 47237451213120PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 502 EDUNAME: db2hadrp (IEONLDB) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetTcpWindowSize, probe:32201
MESSAGE : Info: HADR Socket send buffer size, SO_SNDBUF: 16384 bytes
2013-07-17-09.20.08.341318+480 I820802875E399 LEVEL: Warning
PID : 13824 TID : 47237451213120PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 502 EDUNAME: db2hadrp (IEONLDB) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetTcpWindowSize, probe:32251
MESSAGE : Info: HADR Socket receive buffer size, SO_RCVBUF: 87380 bytes
2013-07-17-09.22.08.696839+480 I820803275E609 LEVEL: Error
PID : 13824 TID : 47237451213120PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 502 EDUNAME: db2hadrp (IEONLDB) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduP, probe:20390
MESSAGE : HADR primary did not establish connection with standby within timeout
and will shut down. BY FORCE option required to start primary without
standby. Timeout seconds =
DATA #1 : Hexdump, 4 bytes
0x00002AF8526C3948 : 7800 0000 x...
2013-07-17-09.22.08.697078+480 I820803885E448 LEVEL: Error
PID : 13824 TID : 47237451213120PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 502 EDUNAME: db2hadrp (IEONLDB) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduP, probe:20390
RETCODE : ZRC=0x8280001A=-2105540582=HDR_ZRC_NO_STANDBY
"Comm time-out in unforced HADR primary start, to avoid split-brain"
2013-07-17-09.22.08.697250+480 I820804334E349 LEVEL: Warning
PID : 13824 TID : 47237451213120PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 502 EDUNAME: db2hadrp (IEONLDB) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduP, probe:20302
MESSAGE : Info: Primary Finished.
2013-07-17-09.22.08.697366+480 I820804684E452 LEVEL: Error
PID : 13824 TID : 47237451213120PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 502 EDUNAME: db2hadrp (IEONLDB) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduEntry, probe:21100
RETCODE : ZRC=0x8280001A=-2105540582=HDR_ZRC_NO_STANDBY
"Comm time-out in unforced HADR primary start, to avoid split-brain"
2013-07-17-09.22.08.697769+480 I820805137E582 LEVEL: Severe
PID : 13824 TID : 47237484767552PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : IEONLDB
APPHDL : 0-234 APPID: *LOCAL.db2inst1.130717012007
AUTHID : DB2INST1
EDUID : 421 EDUNAME: db2agent (IEONLDB) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduStartup, probe:21300
MESSAGE : Error: HADR EDU did not start up. HADR role:
DATA #1 : Hexdump, 4 bytes
0x00002AF6557EC4F0 : 0100 0000 ....
2013-07-17-09.22.08.698044+480 I820805720E550 LEVEL: Error
PID : 13824 TID : 47237484767552PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : IEONLDB
APPHDL : 0-234 APPID: *LOCAL.db2inst1.130717012007
AUTHID : DB2INST1
EDUID : 421 EDUNAME: db2agent (IEONLDB) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduStartup, probe:21300
MESSAGE : HADR EDU zrc:
DATA #1 : Hexdump, 4 bytes
0x00002AF6557EC4E8 : 1A00 8082 ....
2013-07-17-09.22.08.698224+480 I820806271E554 LEVEL: Error
PID : 13824 TID : 47237484767552PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : IEONLDB
APPHDL : 0-234 APPID: *LOCAL.db2inst1.130717012007
AUTHID : DB2INST1
EDUID : 421 EDUNAME: db2agent (IEONLDB) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduStartup, probe:21300
MESSAGE : HADR EDU sqlcode:
DATA #1 : Hexdump, 4 bytes
0x0000000200E3111C : 18F9 FFFF ....
两server hadr配置
HADR database role = PRIMARY
HADR local host name (HADR_LOCAL_HOST) = db144.lthj.com
HADR local service name (HADR_LOCAL_SVC) = 55001
HADR remote host name (HADR_REMOTE_HOST) = db164.lthj.com
HADR remote service name (HADR_REMOTE_SVC) = 55002
HADR instance name of remote server (HADR_REMOTE_INST) = db2inst1
HADR timeout value (HADR_TIMEOUT) = 120
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
HADR peer window duration (seconds) (HADR_PEER_WINDOW) = 0
HADR database role = STANDBY
HADR local host name (HADR_LOCAL_HOST) = db164.lthj.com
HADR local service name (HADR_LOCAL_SVC) = 55002
HADR remote host name (HADR_REMOTE_HOST) = db144.lthj.com
HADR remote service name (HADR_REMOTE_SVC) = 55001
HADR instance name of remote server (HADR_REMOTE_INST) = db2inst1
HADR timeout value (HADR_TIMEOUT) = 120
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
HADR peer window duration (seconds) (HADR_PEER_WINDOW) = 0
收起