It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×7,461
×2,351

question asked: Sep 10 '16, 9:33 a.m.
question was seen: 3,275 times
last updated: Sep 20 '16, 1:39 a.m.

Related questions

DB2 Error during JTS/Setup

0
V Niranjan (125●4●53●74) | asked Sep 10 '16, 9:33 a.m.

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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Anthony Corrente (91●4) | answered Sep 11 '16, 7:37 p.m.
Hi Niranjan,

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.
Comments
V Niranjan commented Sep 12 '16, 12:56 p.m.

Hi Anthony

I tried this but did not work.

Any other suggestions?

Regards
Niranjan V

Anthony Corrente commented Sep 20 '16, 1:39 a.m.

Hi Niranjan,

How are you going with this?
Do you still have an issue connecting? If not, how did you resolve it?

Regards,
Anthony.

0
permanent link
Anthony Corrente (91●4) | answered Sep 15 '16, 1:26 a.m.
Hi Niranjan,

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.

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.