IBM Support

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

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error 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 : <preformatted>
    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 : <preformatted>
    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 : <preformatted>
    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.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 m4fp4 or later                           *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.1 m4fp4 or later
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT24424

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-03-19

  • Closed date

    2018-11-29

  • Last modified date

    2018-11-29

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 November 2018