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

Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

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 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