IBM Support

IT11767: DB2 MAY CRASH WITH SQLQGRFWDFEDPREP ON TOP OF CALL STACK WHEN REPLAYING FEDERATED XA LOG RECORDS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 user might hit DB2 crash with similar callstacks like below
    (taking Windows platform as example):
    
    __intel_new_memcpy
    sqlqgRFwdFedPrep
    sqlpRecDbRedo
    sqlprProcDPSrec
    sqlpPRecReadLog
    sqlpParallelRecovery
    sqleSubCoordProcessRequest
    sqeAgent::RunEDU
    sqlzRunEDU
    sqloEDUEntry
    
    
    Situations where this could arise includes explicit rollforward
    after a restore or when performing a rolling upgrade to an HADR
    pair(referred to as "database rollforward operation" below) at
    different fixpack level than the database backup is taken.
    Known situations of exposure includes:
    
    a) the database backup is taken at GA, Fixpack 1, Fixpack 2,
    Fixpack 3 or Fixpack 3a, but database rollforward operation is
    executed on later fix packs, or
    b) the database backup is taken at Fixpack 4, but database
    rollforward operation is executed on any other fix packs, or
    c) the database backup is taken at Fixpack 5 , but
    database rollforward operation is executed on any previous fix
    packs.
    
    Once this fix is installed, please, take a backup. It will work
    well on the level that has this fix.
    Backups taken on previous levels and restored on the level with
    this fix  could have problems.
    If this fix is installed, older backups (taken on levels prior
    to FP5) could still experience this crash.
    

Local fix

  • Upgrade to 10.1 FP5 and up , and take a backup. Backups taken on
    level older then 10.1 FP5 will still experience problems, even
    if this fix is installed.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 10.1 Fix Pack 6                               *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 10.1 Fix Pack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT11767

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-10-14

  • Closed date

    2017-03-02

  • Last modified date

    2017-03-02

  • 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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1"}]

Document Information

Modified date:
26 September 2021