DB2 FOR LUW / DB2FORLUW / 970 - DB2

When Read On Standby is enabled, the DB2 Standby database may 
hang ( and eventually cause the primary database to hang ). 
The db2redom ( redo master ) edu will show a stack with top 
functions : 
 
HdrKickPooledAgents 
HdrForceAppsInReplayOnlyWindow 
 
and there will be an Asynchronous Background Process (ABP or 
db2taskp ) that show as suspended with a stack trace similar to 
: 
 
 
 
thread_wait 
sqloWaitEDUWaitPost 
IntrptWaitLock 
getTaskProAssignment 
main 
abpAgentEntryPoint 
sqleIndCoordProcessRequest 
 
The problem is timing dependent and will not always occur.

**************************************************************** 
* USERS AFFECTED:                                              * 
* HADR users                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade the DB2 server to V9.7 Fix Pack 8                    * 
****************************************************************

On the standby instance set : 
db2set DB2_DISABLE_ABP=ON 
before starting the instance, this will disable the Asynchronous 
background tasks from starting. 
However, this should not be set on the primary as that may cause 
maintenance problems ( e.g. Asynchronous Index Cleanup not 
running . ). 
Hence when a failover happens,  a failback should be done as 
soon as possible, or the registry variable should be unset. 
 
on the standby server.

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
 

This problem has first been fixed in V9.7 Fix Pack 8

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

20.11.2012
19.04.2013
19.04.2013

9.7.FP8