IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    IT25765

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-07-20

  • Closed date

    2018-11-28

  • Last modified date

    2018-11-28

  • 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

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"11.1","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
19 June 2020