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

DB2LOGMGR EDU CRASH IN SPRINTF CALLED FROM SQLPGRETRIEVELOGDISK ON HADR
STANDBY REINTEGRATION

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
When both LOGARCHMETH1 and/or LOGARCHMETH2/FAILARCHPATH are set, 
 
a standby server will attempt to search each location for a 
later version of the log file after seeing this message in the 
db2diag.log : 
 
FUNCTION: DB2 UDB, recovery manager, sqlplfrFMOpenLog, probe:600 
MESSAGE : Extent 203822 in log path may be stale. Trying 
archive. 
 
It's possible that after searching the 1st location ( pointed to 
by LOGARCHMETH1 ), the retrieve request used by the db2logmgr 
gets freed. This then can potentially lead to a crash in the 
db2logmgr edu upon trying the 2nd location ( e.g. pointed to by 
FAILARCHPATH ). 
 
A trap file may show the following list of functions : 
 
strlen 
_doprnt 
sprintf 
sqlpgRetrieveLogDisk 
sqlpgRetrieveLogFile 
sqlpgHandleLogMgrPost 
...
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* HADR users                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* HADR standby crash can occur on reintegration with primary.  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade DB2 server to v9.7 Fixpak 4                          * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
This problem has first been fixed in V9.7 Fixpak 4
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
17.08.2010
24.05.2011
24.05.2011
Problem solved at the following versions (IBM BugInfos)
9.7.
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.4 FixList