DB2 Error during JTS/Setup
Hi
I have installed DB2 10.5 and CLM 6.0.2 osn the same Linux machine and getting the following error in jts.log file during creation of database in jts/setup.
Caused by: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2030][11211][4.17.28] A communication error occurred during operations on the connection's underlying socket, socket input stream,
or socket output stream. Error location: Reply.fill() - insufficient data (-1). Message: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001
at com.ibm.db2.jcc.am.fd.a(fd.java:328)
at com.ibm.db2.jcc.t4.a.a(a.java:526)
at com.ibm.db2.jcc.t4.a.a(a.java:510)
at com.ibm.db2.jcc.t4.a.a(a.java:505)
at com.ibm.db2.jcc.t4.x.b(x.java:294)
at com.ibm.db2.jcc.t4.x.c(x.java:320)
at com.ibm.db2.jcc.t4.x.c(x.java:433)
at com.ibm.db2.jcc.t4.x.v(x.java:1201)
at com.ibm.db2.jcc.t4.ab.b(ab.java:40)
at com.ibm.db2.jcc.t4.o.a(o.java:32)
at com.ibm.db2.jcc.t4.tb.i(tb.java:145)
at com.ibm.db2.jcc.am.uo.kb(uo.java:2161)
at com.ibm.db2.jcc.am.vo.wc(vo.java:3657)
at com.ibm.db2.jcc.am.vo.b(vo.java:4454)
at com.ibm.db2.jcc.am.vo.jc(vo.java:760)
Please let me know.
Regards
Niranjan V
2 answers
are you able to connect to DB2 using a remote client via TCPIP?
If not, you may want to check out this technote:
https://www-304.ibm.com/support/docview.wss?uid=swg21403644
Regards,
Anthony.
Thank you for your reply.
What does your current setup look like on the DB2 side?
What does your configuration look like on the JTS side?
You're using JCC type 4 driver, you'll need to ensure that DB2 listening an a port (by default it's 50000)
If it's listening on 50000, then the information you need to give the JCC driver is typically:
hostname: This would be the host name or ip address of your DB2 server
port: This is the port that DB2 is listening on. eg: 50000 is usually the default.
database name: This is the name of the database to connect to.
cf. : http://www-01.ibm.com/support/docview.wss?uid=swg21443723
Regards,
Anthony.