Symptom
Environment
You observe the following ST22 dumps reporting SQLCODE=-89986 "SQL message: already processing within CLI"
In the dev_w work process logs (DIR_HOME) you also observe the following stack trace referencing "CLI_execCMRIFlushArray" for CLI driver libdb2.so
M SEGV_MAPERR: Address not mapped to object
M 30 (Memory location which caused fault)
M ------------------ C-STACK ----------------------
dw.sapPW1_DVEBMGS00[S](LinStackBacktrace+0x8c)[0x63dfa9]
dw.sapPW1_DVEBMGS00[S](LinStack+0x35)[0x641ff0]
dw.sapPW1_DVEBMGS00[S](CTrcStack2+0x4e)[0x63dd61]
dw.sapPW1_DVEBMGS00[S](SigIGenAction+0x289)[0x18e6b18]
<signal handler called> [0x7fed056eb370]
libdb2.so(CLI_execCMRIFlushArray(CLI_STATEMENTINFO*, CLI_ERRORHEADERINFO*)+0x3c9)[0x7fe74ef7a959]
libdb2.so(SQLSetStmtAttr2(CLI_STATEMENTINFO*, int, void*, int, CLI_ERRORHEADERINFO*)+0x19ac)[0x7fe74eb250cc]
libdb2.so(SQLSetStmtAttrW+0x469)[0x7fe74f02a219]
dbdb2slibx.so[S](endChaining+0xfb)[0x7fe744aa61fb]
dbdb2slibx.so[S](cliEndChaining+0xc4)[0x7fe744aa7ef4]
dbdb2slibx.so[S](db2EndExecutes+0x2f)[0x7fe744a905bf]
dbdb2slibx.so[S](dbslExeModify+0x522)[0x7fe744a85162]
dw.sapPW1_DVEBMGS00[S](dbsl_exe_modify+0x9a)[0x204fb4a]
dw.sapPW1_DVEBMGS00[S](DbDbslStatement::executeUpdate(bool, short)+0x33a)[0x1beb63a]
dw.sapPW1_DVEBMGS00[S](DbDmlCursor::execute()+0x244)[0x1bee284]
dw.sapPW1_DVEBMGS00[S](DbDmlCursorExternal::executeViaDbsl(DbCursorAllocatorScope&, DbDmlStmt const&)+0x33f)[0x1be17bf]
dw.sapPW1_DVEBMGS00[S](DbDmlCursorExternal::execute(DbCursorAllocatorScope&, DbDmlStmt const&)+0xb6)[0x1be1b26]
dw.sapPW1_DVEBMGS00[S](OSqlModifyEntry::execute(DbCursorAllocatorScope&, DbDmlStmt&)+0x98)[0x1c5cca8]
dw.sapPW1_DVEBMGS00[S](ab_jsqln()+0xbc0)[0x1c63530]
dw.sapPW1_DVEBMGS00[S](ab_extri()+0x197)[0x1ae3737]
dw.sapPW1_DVEBMGS00[S](ab_xevent(char16_t const*)+0x32)[0x1b20ab2]
dw.sapPW1_DVEBMGS00[S](ab_dstep+0x36)[0x1ae0c86]
dw.sapPW1_DVEBMGS00[S](dynpmcal(DINFDUMY*, STPDUMMY*)+0x2d1)[0x1d36a51]
dw.sapPW1_DVEBMGS00[S](dynppbo0(DINFDUMY*)+0xb6)[0x1d38956]
dw.sapPW1_DVEBMGS00[S](dynprctl(DINFDUMY*)+0x189)[0x1d39059]
dw.sapPW1_DVEBMGS00[S](dynpen00+0x3d7)[0x1d29f07]
dw.sapPW1_DVEBMGS00[S](ab_HttpRequestHandler(TH_PLUGIN_ROLE, TH_PLUGIN_ACTION, int, TH_PLUGIN_PROTOCOL, unsigned char)+0x7d5)[0x1f85
dw.sapPW1_DVEBMGS00[S](PluginHandler::handleRequest(REQUEST_BUF*, bool)+0x41a)[0x1d00faa]
dw.sapPW1_DVEBMGS00[S](ThHandleRequest(REQUEST_BUF*, unsigned char)+0x19c)[0x1cd13ac]
dw.sapPW1_DVEBMGS00[S](TskhLoop()+0xa5)[0x1acf355]
dw.sapPW1_DVEBMGS00[S](ThStart()+0x284)[0x4dbcfe]
dw.sapPW1_DVEBMGS00[S](DpMain+0x35b)[0x1c6a21b]
libc.so.6[S](__libc_start_main+0xf5)[0x7fed0533cb35]
M -------------------------------------------------
M caught SIGSEGV (11)
M ThSigHandler (0, Signal)
M in_ThErrHandle: 1
M ThIErrHandle: set thRc ERROR-CORE-ABORTED_BY_SIGNAL for T2_U8470_M0
M ThResetEmMagic: reset em magic for T2_U8470_M0_I0
M ThSigHandler: Signal for T2_U8470_M0 (step TH_WORK_SYNC, thRc ERROR-CORE-ABORTED_BY_SIGNAL, action RETURN_FOR_DUMP)
M DpCheckSoftCancel: reset SOFT_CANCEL for T2_U8470_M0
M DpCheckSoftCancel: softcancel schedule 14 for T2_U8470_M0 will be deleted explicitly
Followed by SQLCODE -89986 errors:
C *** ERROR => DB2 Call 'SQLFreeHandle' Error: SQLCODE = -89986 : already processing within CLI
[dbdb2cli.c 6116]
M ThEppGetConnectionCounter: read connectionCounter 1 from epp 0
C *** ERROR => DB2 Call 'SQLFreeHandle' Error: SQLCODE = -89986 : already processing within CLI
[dbdb2cli.c 6116]
M ThEppGetConnectionCounter: read connectionCounter 1 from epp 0
C *** ERROR => DB2 Call 'SQLFreeHandle' Error: SQLCODE = -89986 : already processing within CLI
[dbdb2cli.c 6116]
M ThEppGetConnectionCounter: read connectionCounter 1 from epp 0
C *** ERROR => DB2 Call 'SQLFreeHandle' Error: SQLCODE = -89986 : already processing within CLI
[dbdb2cli.c 6116]
Product
Keywords
Netweaver DB2 CLI JDBC ODBC DB2 Connect z/OS , KBA , BC-DB-DB2-DBA , DB2 for z/OS - Database administration , BC-DB-DB2 , DB2 for z/OS , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview