IT25765: DB2 CLIENT FAILS WITH SIGSEGV OR GIVES SQL ERRORS WHEN embeddedSQL application EXECUTES MULTI ROW INSERT

APAR status

• Closed as program error.

Error description

• In embeddedSQL application, when doing the array insert using
  the multi-row insert feature of the embeddedSQL, if we have the
  different sizes of data in the array, embddedSQL application may
  crash with the following stack.
  
  For example:  copying form dump files
  <StackTrace>
  -------Frame------ ------Function + Offset------
  0x000000000000F5AC ?unknown + 0x0
  0x090000000A500E98
  clientbiPutVarcharDataSpanBuffers__FP14CLIENTBI_PARMSPcsT3 +
  0x238
                   [ NO FDPR ] ( = offset 0xC7EA98 in library
  /home/jplincdl/sqllib/lib64/libdb2.a )
  0x090000000A6CB868 sqlak_callbDrdaInput__FP14db2UCinterface +
  0x35E8
                   [ NO FDPR ] ( = offset 0xE49468 in library
  /home/jplincdl/sqllib/lib64/libdb2.a )
  0x090000000A14AE6C sqljrGenSqlDta__FP14db2UCinterfaceUi + 0x56C
                   [ NO FDPR ] ( = offset 0x8C8A6C in library
  /home/jplincdl/sqllib/lib64/libdb2.a )
  0x090000000A688414
  sqljrDrdaArArrayInput__FP14db2UCinterfacePP15db2UCdiagStructUlUs
  + 0xBF4
                   [ NO FDPR ] ( = offset 0xE06014 in library
  /home/jplincdl/sqllib/lib64/libdb2.a )
  0x090000000A215FFC sqlacall + 0x355C
                   [ NO FDPR ] ( = offset 0x993BFC in library
  /home/jplincdl/sqllib/lib64/libdb2.a )
  0x0000000100109C68
  execMultiRowInsert__13db2SqlStmtMgrFCPCcRCPC6lpdataPP13sqlStmtHa
  ndleR15sqlStmtInfoTypeCUsCP5sqldai + 0x1368
  0x000000010032B4C4
  runMultirowInsertSQL__7subsSQLFCP6dbConnP5QAsubP5sqldaP4stmtR15s
  qlStmtInfoTypeCUs + 0x344
  0x0000000100364098
  insertMRI__5QArowFP7appAgntP7agntSubCP14updateStmtDesc + 0x298
  0x000000010035D6FC
  applyMultiRow__5QArowFP7appAgntP7agntSubPC10encodeInfoiPP5QArow
  + 0x41C
  0x000000010035B8A0 applyTran__5QAtxsFP7appAgntP7ASNBOOL + 0xAC0
  0x00000001003250C4 appAgntMain__FP9asnThread + 0x5C64
  0x0900000000519E10 _pthread_body + 0xF0
                   [ NO FDPR ] ( = offset 0x3E10 in library
  /usr/lib/libpthreads.a )
  </StackTrace>
  

Local fix

• NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * embeddedSQL applications using array insert.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Please upgrade to DB2 v11.1 m4fp4 or later.                  *
  ****************************************************************
  

Problem conclusion

• Please upgrade to DB2 v11.1 m4fp4 or later.
  

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:

Fix information

• Fixed component name

  DB2 CONNECT

• Fixed component ID

  DB2CONNCT

Applicable component levels

• RB10 PSN

     UP