hadr主库不能启动
SQL1768N Unable to start HADR. Reason code = "7". 为启动时的错误提示
db2diag中报错:
2012-09-01-08.40.02.680289+480 I4322G294 LEVEL: Warning
PID : 4523 TID : 3086862016 PROC : db2hadrp (SAMPLE) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduP, probe:20301
MESSAGE : Info: Primary Started.
2012-09-01-08.40.02.680870+480 I4617G342 LEVEL: Warning
PID : 4523 TID : 3086862016 PROC : db2hadrp (SAMPLE) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetTcpWindowSize, probe:32201
MESSAGE : Info: HADR Socket send buffer size, SO_SNDBUF: 16384 bytes
2012-09-01-08.40.02.681016+480 I4960G345 LEVEL: Warning
PID : 4523 TID : 3086862016 PROC : db2hadrp (SAMPLE) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetTcpWindowSize, probe:32251
MESSAGE : Info: HADR Socket receive buffer size, SO_RCVBUF: 87380 bytes
2012-09-01-08.45.03.637704+480 I5306G547 LEVEL: Error
PID : 4523 TID : 3086862016 PROC : db2hadrp (SAMPLE) 0
INSTANCE: db2inst1 NODE : 000
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
0x139BAD40 : 2C01 0000 ,...
2012-09-01-08.45.03.638333+480 I5854G394 LEVEL: Error
PID : 4523 TID : 3086862016 PROC : db2hadrp (SAMPLE) 0
INSTANCE: db2inst1 NODE : 000
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"
2012-09-01-08.45.03.638929+480 I6249G295 LEVEL: Warning
PID : 4523 TID : 3086862016 PROC : db2hadrp (SAMPLE) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduP, probe:20302
MESSAGE : Info: Primary Finished.
2012-09-01-08.45.03.639073+480 I6545G398 LEVEL: Error
PID : 4523 TID : 3086862016 PROC : db2hadrp (SAMPLE) 0
INSTANCE: db2inst1 NODE : 000
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"
2012-09-01-08.45.03.639419+480 E6944G314 LEVEL: Event
PID : 4523 TID : 3086862016 PROC : db2hadrp (SAMPLE) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetDbRole, probe:10010
CHANGE : HADR role set to Standard (was Primary)
2012-09-01-08.45.03.648011+480 I7259G496 LEVEL: Severe
PID : 2753 TID : 3086862016 PROC : db2agent (SAMPLE) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-522 APPID: *LOCAL.db2inst1.120901004002
AUTHID : DB2INST1
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
0xBFDC046C : 0100 0000 ....
2012-09-01-08.45.03.648348+480 I7756G464 LEVEL: Error
PID : 2753 TID : 3086862016 PROC : db2agent (SAMPLE) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-522 APPID: *LOCAL.db2inst1.120901004002
AUTHID : DB2INST1
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduStartup, probe:21300
MESSAGE : HADR EDU zrc:
DATA #1 : Hexdump, 4 bytes
0xBFDC043C : 1A00 8082 ....
2012-09-01-08.45.03.648548+480 I8221G468 LEVEL: Error
PID : 2753 TID : 3086862016 PROC : db2agent (SAMPLE) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-522 APPID: *LOCAL.db2inst1.120901004002
AUTHID : DB2INST1
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduStartup, probe:21300
MESSAGE : HADR EDU sqlcode:
DATA #1 : Hexdump, 4 bytes
0xB7FD4A7C : 18F9 FFFF ....
2012-09-01-08.45.03.648697+480 I8690G415 LEVEL: Severe
PID : 2753 TID : 3086862016 PROC : db2agent (SAMPLE) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-522 APPID: *LOCAL.db2inst1.120901004002
AUTHID : DB2INST1
FUNCTION: DB2 UDB, base sys utilities, sqlesrsu, probe:17
DATA #1 : Hexdump, 4 bytes
0xB7FD4A7C : 18F9 FFFF ....
主库相关参数:
HADR local host name (HADR_LOCAL_HOST) = 192.168.0.88
HADR local service name (HADR_LOCAL_SVC) = DB2_HADR_1
HADR remote host name (HADR_REMOTE_HOST) = 192.168.0.77
HADR remote service name (HADR_REMOTE_SVC) = DB2_HADR_2
HADR instance name of remote server (HADR_REMOTE_INST) = db2inst1
HADR timeout value (HADR_TIMEOUT) = 300
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
备库相关参数:
HADR local host name (HADR_LOCAL_HOST) = 192.168.0.77
HADR local service name (HADR_LOCAL_SVC) = DB2_HADR_2
HADR remote host name (HADR_REMOTE_HOST) = 192.168.0.88
HADR remote service name (HADR_REMOTE_SVC) = DB2_HADR_1
HADR instance name of remote server (HADR_REMOTE_INST) = db2inst1
HADR timeout value (HADR_TIMEOUT) = 300
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
主库和备库的/etc/services文件相关的部分:
DB2_HADR_1 55001/tcp
DB2_HADR_2 55002/tcp