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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.