While doing rolling update,take over command gives communication
error e.g:-
[db2v10@ts-test db2dump]$ db2 takeover hadr on db hadr
SQL1770N Takeover HADR cannot complete. Reason code = "7".
db2diag.log entry:-
2014-06-05-15.56.20.669781-300 I555680A573 LEVEL: Error
PID : 21889254 TID : 4113 PROC
:db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
sample
APPHDL : 0-9 APPID:
*LOCAL.db2inst1.140605205608
AUTHID : db2inst1 HOSTNAME: test
EDUID : 4113 EDUNAME: db2agent (Z41) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery,
hdrTakeoverHdrRouteIn, probe:55610
RETCODE : ZRC=0x8280001B=-2105540581=HDR_ZRC_COMM_CLOSED
"Communication with HADR partner was lost"
2014-06-05-15.56.22.097635-300 I556708A642 LEVEL: Error
PID : 21889254 TID : 10282 PROC
:db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
sample
HOSTNAME: test
EDUID : 10282 EDUNAME: db2hadrp.0.1 (Z41) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery,
hdrVerifySystem, probe:15510
MESSAGE : ZRC=0x87800140=-2021654208=HDR_ZRC_CONFIGURATION_ERROR
"One or both databases of the HADR pair is configured
incorrectly"
DATA #1 : <preformatted>
The db2 release level on this machine, SQL10014, is different
from that on the remote machine, SQL10013.
2014-06-05-15.56.22.098522-300 E557351A677 LEVEL: Error
PID : 21889254 TID : 10282 PROC
:db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
sample
HOSTNAME: test
EDUID : 10282 EDUNAME: db2hadrp.0.1 (Z41) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery,
hdrVerifySystem, probe:15510
MESSAGE : ADM12502E Unable to establish HADR primary-standby
connection because the DB2 versions do not match the primary and
standby databases. Upgrade the DB2 software to the same
release and FixPak on either the HADR primary or HADR standby
database to
match the other. |
