MQSeries.net :: View topic - WTX

ein · Posted: Tue Jun 14, 2011 11:21 pm Post subject: WTX - DB2 communication failure

Hi,

We are facing an inconsistency in WTX - DB2 connection, some times when WTX map hits the database for the first time a DB2 disconnect is happening, we have captured the error log below,
can some advice how to resolve this issue? We are using WTX 8.3 version with WMB 7.0

We are using PUT function to insert data into DB2 tables

Log file
<22359-495326160>: Error in SQLNumResultCols
Message: IBMCLI Driver CLI0108E Communication link failure. SQLSTATE=40003
SQL State: 40003
<22359-495326160>: No columns found for table Schemaname.tablename: table name is likely to be invalid.
<22359-495326160>: Error in SQLAllocStmt
Message: IBMCLI Driver CLI0106E Connection is closed. SQLSTATE=08003
SQL State: 08003

Below resoponse we got from DBA, can some one advice how to achive this in WTX.
CLI0108E Communication link failure.

Explanation:

The connection between the driver and the data source failed
during execution of this function.

User Response:

Establish a new connection.

It appears as though the connection may have been closed due to inactivity. Can you try the process immediately after making the connection?