IBM Support

IT29633: INTERRUPTING ROLLFORWARD OPERATIONS DURING REPLAY CAN CAUSE SUBSEQUENT ROLLFORWARD TO FAIL

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Restarting the standby database during replay might fail
    indicated by the following db2diag.log message:
    
    FUNCTION: DB2 UDB, data management, sqldRedoUpsert, probe:2251
    MESSAGE : Free Space does not match during redo!
    DATA #1 : String, 11 bytes
    insinfo_lr:
    DATA #2 : Hexdump, 26 bytes
    0x00007F6CBC03A5A0 : 01A2 2A00 6405 0000 2A00 203B 0400 0000
    ..*.d...*. ;....
    0x00007F6CBC03A5B0 : 0000 2A3B 0000 2A00 0100 ..*;..*...
    DATA #3 : String, 11 bytes
    Space used:
    DATA #4 : signed integer, 4 bytes
    42
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
    [0] 0x00007FEF403F60D3 /db2/db2pb3/sqllib/lib64/libdb2e.so.1 +
    0x224A0D3
    [1] 0x00007FEF403E8FA2
    _Z8sqldRedoP8sqeAgentP8SQLD_LRHP9SQLP_LSN8mmm + 0x1A52
    [2] 0x00007FEF403B2001
    _Z8sqldmrdoP8sqeAgenttP9SQLP_LSN8PcmmmmP8SQLP_TIDP15SQLD_RECOV_I
    NFO + 0xD01
    [3] 0x00007FEF45939B4B
    _Z13sqlpRecDbRedoP8sqeAgentP8SQLP_ACBP14sqlpMasterDbcbP10SQLP_FR
    APPP11SQLP_TENTRYP16SQLPR_LOGREC_DISP10REDO_INPUT + 0x273B
    [4] 0x00007FEF45937073
    _Z15sqlpPRecProcLogP8sqeAgentP8SQLP_ACBP14sqlpMasterDbcb +
    0x14D3
    [5] 0x00007FEF458F479E _Z20sqlpParallelRecoveryP8sqeAgentP5sqlca
    + 0xF6E
    [6] 0x00007FEF437BB24C _Z26sqleSubCoordProcessRequestP8sqeAgent
    + 0x17C
    [7] 0x00007FEF437D80AE _ZN8sqeAgent6RunEDUEv + 0x5AE
    [8] 0x00007FEF470F8CBE _ZN9sqzEDUObj9EDUDriverEv + 0x1BE
    [9] 0x00007FEF4561EE1A sqloEDUEntry + 0x57A
    [10] 0x00007FEF4D1B5DD5 /lib64/libpthread.so.0 + 0x7DD5
    [11] 0x00007FEF3CC59B3D clone + 0x6D
    
    Other cases include crash recovery or rollforward operations.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT29633

  • 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

    2019-07-05

  • Closed date

    2020-01-16

  • Last modified date

    2020-01-16

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

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

    IT29634

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:
16 January 2020