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","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"11.1","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
14 December 2020