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.