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

GRACEFUL TAKEOVER IS SLOW DUE TO UNDO WAS FIGHTING LOGGR PRE-ALLOCATION

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
Graceful takeover was slow, in the minutes.  This was because 
takeover was being issued shortly after the primary activated 
and we had not internally pre-allocated log active.  So when the 
takeover request came in and on the primary we had quite a few 
transaction to rollback, undo was fighting db2loggr 
pre-allocation. 
We spent too much time in pre-allocation not enough time 
servicing read log requests for undo. 
 
This is a regression due to our recent changes to allocate 2 
files on startup and the remaining files after the fact. 
 
The solution is a cheap fix.  While takeover is in progress to 
avoid doing any file pre-allocation.  This way db2loggr is 
focused 
on rollback not taking up cycles allocating files.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* HADR takeover slow                                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to v101fp5 or v105fp5.                               * 
****************************************************************
Local Fix:
If possible, before issuing the graceful TAKEOVER, wait until 
all logs in the active log path are pre-allocated.
Solution
the fix will be delivered to v101 and v105. the slow takeover 
problem will be resolved.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
21.08.2014
13.07.2015
13.07.2015
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