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

FIRST TAKEOVERS AFTER MIGRATION FROM 9.7 TO 11.X CAN LOOP IN
REMOVEEXTRACANDIDATES FUNCTION AND TIMEOUT

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem description:
This situation seems to occur on the first two takeovers after
migration from 9.7 to 11.x (failover and back the first time).
After the first two takeovers, the structures in the LFH/GLFH
files seems to be up to date and subsequent takeovers no longer
exhibit this behavior.

Observed behavior in the db2diag.log

2018-02-22-16.45.14.951000-300 I54293F471           LEVEL: Info
PID     : 1932                 TID : 2848           PROC :
db2syscs.exe
INSTANCE: DB2                  NODE : 000           DB   :
SAMPLE
HOSTNAME: MYSERVER
EDUID   : 2848                 EDUNAME: db2logalloc.0 (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services,
sqlpLogAllocCandidatePool::removeExtraCandidates, probe:10100
DATA #1 : 
log extent 0 is deleted. logStreamId is: 0

2018-02-22-16.45.14.951000-300 I54766F471           LEVEL: Info
PID     : 1932                 TID : 2848           PROC :
db2syscs.exe
INSTANCE: DB2                  NODE : 000           DB   :
SAMPLE
HOSTNAME: MYSERVER
EDUID   : 2848                 EDUNAME: db2logalloc.0 (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services,
sqlpLogAllocCandidatePool::removeExtraCandidates, probe:10100
DATA #1 : 
log extent 1 is deleted. logStreamId is: 0

(...)

2018-02-22-21.09.44.641000-300 I929973953F477       LEVEL: Info
PID     : 1932                 TID : 2848           PROC :
db2syscs.exe
INSTANCE: DB2                  NODE : 000           DB   :
SAMPLE
HOSTNAME: MYSERVER
EDUID   : 2848                 EDUNAME: db2logalloc.0 (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services,
sqlpLogAllocCandidatePool::removeExtraCandidates, probe:10100
DATA #1 : 
log extent XXXXXXX is deleted. logStreamId is: 0

Where XXXXXXX is the current first active log.

**********
If the above takes too long, HADR will fail to connect due to
exceeding the timeout.
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 m4fp4 or later                           *
****************************************************************
Local Fix:
N/A
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
19.03.2018
29.11.2018
29.11.2018
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)