SAP Knowledge Base Article - Preview

2783942 - SQLCODE -518 error message reported - CHAINING_END

Symptom

You notice that work processes are terminating with runtime errors and dumps being written out.  The following error is reported in the work process logs DIR_WORK:

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
C Tue Apr 2 10:32:16:351 2019
C DB2 Call 'SQLGetConnectAttrW' Warning: conHdl = 00 SQLCODE = 88888 : [IBM][CLI Driver] CLI0212W A seamless failover occurred during a connect or an execute request. SQLSTATE=01000
C CLI failover to server AMP1 occurred!
B RECONNECT: rsdb/reco_trials: 3
B RECONNECT: rsdb/reco_sleep_time: 5
B ***LOG BV4=> reconnect state is set for the work process [dblink 2320]
B ***LOG BYY=> work process left reconnect status [dblink 2321]
M ThHdlReconnect: reconnect o.k.
C
C Tue Apr 2 11:23:58:587 2019
C *** ERROR => DB2 Call 'SQLSetStmtAttr CHAINING_END' Error: conHdl = 00 SQLCODE = -518 : [IBM][CLI Driver][DB2] THE EXECUTE STATEMENT DOES NOT IDENTIFY A VALID PREPARED STATEMENT
[dbdb2cli.c 6571]
C {root-id=005056860FB31EE995AC5F83EFA26F62}_{conn-id=B16355E9531CF178AF62005056860FB3}_0
C DB2Trc: INSERT INTO "VBPA" VALUES( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?\
C DB2Trc: , ? , ? , ? , ? , ? , ? ) ;
B ***LOG BY4=> sql error -518 performing INS on table VBPA [dbdbslst 4639]
B ***LOG BY0=> [IBM][CLI Driver][DB2] THE EXECUTE STATEMENT DOES NOT IDENTIFY A VALID PREPARED STATEMENT [dbdbslst 4639]
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


Read more...

Environment

  • IBM DB2 z/OS
  • IBM DB2 Driver for CLI,ODBC,JDBC,SQLJ V11.1 FP1 or earlier

Product

SAP ERP 6.0 ; SAP NetWeaver Application Server all versions

Keywords

SQL0518N CHAINING_BEGIN SQL_ATTR_CHAINING_BEGIN SQL_ATTR_CHAINING_END , KBA , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.