home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT02964 Status: Closed

DB2 ROLLING UPDATE GIVES SQL1770N TAKEOVER HADR CANNOT COMPLETE. REASON
CODE = "7" WHILE TAKE OVER COMMAND

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
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.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.1 Fix Pack 5                               * 
****************************************************************
Local Fix:
Solution
First fixed in DB2 10.1 Fix Pack 5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
03.07.2014
17.02.2017
17.02.2017
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.5 FixList