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 IC98615 Status: Closed

IN A TSA/HADR ENVIRONMENT, AUTOMATIC REINTEGRATION OF THE HADR STANDBY
DATABASE FAILS

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
In the case where the server hosting the primary HADR database 
fails, the standby HADR database becomes the new primary, but 
the old primary may fail to reintegrate itself as the new 
standby database. In this scenario, the user will need to 
manually reintegrate the old primary as the new standby. In this 
scenario, the following error messages are expected to be seen 
in the db2diag.log on the server which encountered the original 
failure: 
 
2013-11-06-11.27.25.266888-300 E3596315E520          LEVEL: 
Event 
PID     : 5981                 TID : 47691006469888  PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000            DB   : 
HADRDB 
APPHDL  : 0-970                APPID: 
*LOCAL.db2inst1.131106163746 
AUTHID  : DB2INST1             HOSTNAME: host01 
EDUID   : 145                  EDUNAME: db2agent (HADRDB) 0 
FUNCTION: DB2 UDB, base sys utilities, 
sqeDBMgr::StartUsingLocalDatabase, probe:13 
START   : Received START HADR SECONDARY command. 
 
2013-11-06-11.27.28.290831-300 I3691557E942          LEVEL: 
Error 
PID     : 22342                TID : 47836474602240  PROC : 
db2gcf 
INSTANCE: db2inst1             NODE : 000 
HOSTNAME: host01 
FUNCTION: DB2 Common, Generic Control Facility, gcf_getstate, 
probe:260 
DATA #1 : String, 83 bytes 
Unable to automatically reintegrate database HADRDB. Please 
reintegrate manually. 
CALLSTCK: (Static functions may not be resolved correctly, as 
they are resolved to the nearest symbol) 
  [0] 0x00002B81C6E2AC39 pdOSSeLoggingCallback + 0x219 
  [1] 0x00002B81C61350AB 
/mnt/db2/data/db2inst1/sqllib/lib64/libdb2osse.so.1 + 0x2070AB 
  [2] 0x00002B81C6134ED3 ossLog + 0xA3 
  [3] 0x00002B81CE4F0872 gcf_getstate + 0x1A52 
  [4] 0x00002B81C6656457 
_ZN9GcfCaller8getStateEP12GCF_PartInfomP11GCF_RetInfo + 0x187 
  [5] 0x0000000000403D23 main + 0x1023 
  [6] 0x00002B81CA16EC16 __libc_start_main + 0xE6 
  [7] 0x0000000000402C69 __gxx_personality_v0 + 0xD9
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Cancun Release 10.5.0.4 (also known as Fix    * 
* Pack 4) or higher                                            * 
****************************************************************
Local Fix:
N/A
available fix packs:
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Solution
First Fixed in DB2 Cancun Release 10.5.0.4 (also known as Fix 
Pack 4)
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
08.01.2014
16.10.2014
16.10.2014
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.5.0.4 FixList