Hello.
I want to create an HADR Database.
We have 2 systems therefore with DB2 9.7 Workgroup Edition x64.
I have installed the DB2 under SLES11.
We have create 1 Database and created our HADR.
After change to standby system and then switch back to the primary system
the "Connection Status" was Disconnected.
So for testing we dropped the Database and recreated it.
If we now want to create the HADR it get failed.
Message on the primary system:
2010-02-26-15.07.44.121975+060 I4853860E396 LEVEL: Warning
PID : 6259 TID : 139731698444624PROC : db2sysc
INSTANCE: db2hadr1 NODE : 000
EDUID : 3384 EDUNAME: db2hadrp (UDBSORT)
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetTcpWindowSize, probe:32251
MESSAGE : Info: HADR Socket receive buffer size, SO_RCVBUF: 87380 bytes
2010-02-26-15.09.45.129041+060 I4854257E606 LEVEL: Error
PID : 6259 TID : 139731698444624PROC : db2sysc
INSTANCE: db2hadr1 NODE : 000
EDUID : 3384 EDUNAME: db2hadrp (UDBSORT)
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
0x00007F155F298F08 : 7800 0000 x...
2010-02-26-15.09.45.129196+060 I4854864E445 LEVEL: Error
PID : 6259 TID : 139731698444624PROC : db2sysc
INSTANCE: db2hadr1 NODE : 000
EDUID : 3384 EDUNAME: db2hadrp (UDBSORT)
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"
2010-02-26-15.09.45.129304+060 I4855310E346 LEVEL: Warning
PID : 6259 TID : 139731698444624PROC : db2sysc
INSTANCE: db2hadr1 NODE : 000
EDUID : 3384 EDUNAME: db2hadrp (UDBSORT)
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduP, probe:20302
MESSAGE : Info: Primary Finished.
2010-02-26-15.09.45.129359+060 I4855657E449 LEVEL: Error
PID : 6259 TID : 139731698444624PROC : db2sysc
INSTANCE: db2hadr1 NODE : 000
EDUID : 3384 EDUNAME: db2hadrp (UDBSORT)
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"
2010-02-26-15.09.45.129484+060 E4856107E365 LEVEL: Event
PID : 6259 TID : 139731698444624PROC : db2sysc
INSTANCE: db2hadr1 NODE : 000
EDUID : 3384 EDUNAME: db2hadrp (UDBSORT)
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetDbRole, probe:10010
CHANGE : HADR role set to Standard (was Primary)
2010-02-26-15.09.45.130060+060 I4856473E579 LEVEL: Severe
PID : 6259 TID : 139731815885136PROC : db2sysc
INSTANCE: db2hadr1 NODE : 000 DB : UDBSORT
APPHDL : 0-1274 APPID: *LOCAL.db2hadr1.100226140940
AUTHID : DB2HADR1
EDUID : 3373 EDUNAME: db2agent (UDBSORT)
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
0x00007F15D93F1AF0 : 0100 0000 ....
2010-02-26-15.09.45.130151+060 I4857053E547 LEVEL: Error
PID : 6259 TID : 139731815885136PROC : db2sysc
INSTANCE: db2hadr1 NODE : 000 DB : UDBSORT
APPHDL : 0-1274 APPID: *LOCAL.db2hadr1.100226140940
AUTHID : DB2HADR1
EDUID : 3373 EDUNAME: db2agent (UDBSORT)
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduStartup, probe:21300
MESSAGE : HADR EDU zrc:
DATA #1 : Hexdump, 4 bytes
0x00007F15D93F1AE8 : 1A00 8082 ....
2010-02-26-15.09.45.130227+060 I4857601E551 LEVEL: Error
PID : 6259 TID : 139731815885136PROC : db2sysc
INSTANCE: db2hadr1 NODE : 000 DB : UDBSORT
APPHDL : 0-1274 APPID: *LOCAL.db2hadr1.100226140940
AUTHID : DB2HADR1
EDUID : 3373 EDUNAME: db2agent (UDBSORT)
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduStartup, probe:21300
MESSAGE : HADR EDU sqlcode:
DATA #1 : Hexdump, 4 bytes
0x00000002025658D4 : 18F9 FFFF ....
2010-02-26-15.09.45.130328+060 I4858153E519 LEVEL: Severe
PID : 6259 TID : 139731815885136PROC : db2sysc
INSTANCE: db2hadr1 NODE : 000 DB : UDBSORT
APPHDL : 0-1274 APPID: *LOCAL.db2hadr1.100226140940
AUTHID : DB2HADR1
EDUID : 3373 EDUNAME: db2agent (UDBSORT)
FUNCTION: DB2 UDB, base sys utilities, sqeApplication::AppStartUsing, probe:17
DATA #1 : Hexdump, 4 bytes
0x00000002025658D4 : 18F9 FFFF ....
2010-02-26-15.09.45.417725+060 E4858673E470 LEVEL: Event
PID : 6259 TID : 139731815885136PROC : db2sysc
INSTANCE: db2hadr1 NODE : 000 DB : UDBSORT
APPHDL : 0-1274 APPID: *LOCAL.db2hadr1.100226140940
AUTHID : DB2HADR1
EDUID : 3373 EDUNAME: db2agent (idle)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000
STOP : DATABASE: UDBSORT : DEACTIVATED: NO
2010-02-26-15.09.45.457461+060 I4859144E830 LEVEL: Error
PID : 18680 TID : 140431640938832PROC : db2dasstm
INSTANCE: db2hadr1 NODE : 000
FUNCTION: DB2 Tools, DB2 administration server, handleRunCmd, probe:85
DATA #1 : signed integer, 4 bytes
-1768
CALLSTCK:
[0] 0x00007FB8CD263254 pdOSSeLoggingCallback + 0x100
[1] 0x00007FB8D1A5BFF4 /home/db2hadr1/sqllib//lib64/libdb2osse.so.1 + 0x1C0FF4
[2] 0x00007FB8D1A5D810 ossLog + 0xA6
[3] 0x000000000040C64D _Z12handleRunCmdP17stmRequestContext + 0xC51
[4] 0x0000000000409110 db2dasStmRequestDispatchThread + 0x6C
[5] 0x00007FB8D13E90FB db2dasThreadMain + 0x37
[6] 0x00007FB8D091C070 /lib64/libpthread.so.0 + 0x7070
[7] 0x00007FB8CFF1511D clone + 0x6D
[8] 0x0000000000000000 ?unknown + 0x0
[9] 0x0000000000000000 ?unknown + 0x0
On the standby systems no message occours.
Have anyone an idea?
If we create another Database, it will work fine.
Thank you.
Kind Regards.
Rolf