DB2 FOR LUW / DB2FORLUW / A50 - DB2

When a TAKEOVER command is issued to change the database role, 
the database is opened to application connections immediately 
after the role change, before the TAKEOVER command completes all 
of its processing.  If user issues CREATE / DROP / ALTER 
TABLESPACE command on the connection to the new primary, before 
TAKEOVER command returns, there is a chance that this can create 
a timing window that would cause the TAKEOVER command to hang. 
 
If the TAKEOVER command is hung, then if any stack tracebacks 
are created 
one will see the following functions listed that can provide 
insight as to whether you hit this problem: 
 
If the TAKEOVER command is hung, the root cause can be confirmed 
by db2pd -stack.  The db2hadrs EDU would have the following 
stack: 
 
getConflictComplex 
getConflict 
sqlbQryPools 
sqlbGetDatapools 
hdrVerifyPoolStatesOnPrimaryStartup 
hdrEduStartup 
hdrStbyTkHandlePrimaryDone 
hdrSDoTakeover 
 
while one of the agent EDU has the following stack: 
 
sqloWaitThreshold 
sqlpgild 
sqlpWriteToLog 
sqlpWriteLR 
sqlbCreatePool 
sqldPoolCreate 
sqlrlCreateTablespace 
sqlnq_create_tablespace_end 
sqlnq_create_tablespace_stmt 
 
(The above stack can be slightly different for DROP / ALTER 
TABLESPACE.)

**************************************************************** 
* USERS AFFECTED:                                              * 
* HADR                                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.5.5.                                       * 
****************************************************************

Once hung there is no workaround.  To avoid the issue, wait 
until the TAKEOVER is complete before starting new workload on 
the new Primary.

The fix will be delivered to DB2 10.5.5 and at that time the 
hang will no longer be seen.

keiner bekannt / siehe Local-Fix

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

17.09.2014
15.12.2014
15.12.2014