DB2 SENDER ADAPTER ERROR:[IBM][JDBC Driver] CLI0616E Error opening socket.

[daixiong_jiang3]

Hi gurus,

I am using pi7.1 and want to use the JDBC SENDER ADAPTER to get data from a DB2 database.

Firstly i got the file db2java.jar from the DB2 administrator and then add it to the file com.sap.aii.adapter.lib.sda, then deploy it successfully.

I use the following connection parameters :

JDBC Driver: COM.ibm.db2.jdbc.net.DB2Driver  (type 4)
connection: jdbc:db2://<ip>:6789/test

and the SQL statement:

SELECT  T1.FIELD1,  
              T1.FIELD2,
              T2.FIELD3,  
              T2.FIELD4, 
              T3.FIELD5  
              T3.FIELD6,  
              T4.FIELD7,  
              T4.FIELD8,  
   FROM T1    left JOIN T2 ON 
                      left JOIN T3 ON
                     left JOIN  T4 ON
   where ......

Then the error comes:

COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0616E  Error opening socket. SQLSTATE=08S01'

so what the possible reason is and how should i correct the issue?

thanks a lot.

Dario

Edited by: Daixiong Jiang on Aug 10, 2010 10:04 AM

[Former Member]

Hi,

A Server Service named DB2 JDBC Applet Server is required to be running on the server where the DB2 Server is running. If the DB2 JDBC Applet Server service is not running you will get this message.

Also, you may need to start the DB2 JDBC Applet Server using db2jstrt <port number> . You may have specified a wrong port number, or an incorrect hostname/IP Address.

Regards,

Neetesh