• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 15073
  • Last Modified:

db2 - jdbc problem

I've got some problem with db2-jdbc:
I've got UDB Personal on Win 2000 and I can't connect to my server /UDB on Linux/, from java.
I've done it with the following driver/dburl:
COM.ibm.db2.jdbc.app.DB2Driver
jdbc:db2:DATABASE
But, if I set the URL on the following way:
ConnectionURL=jdbc:db2://hostname:523/DBName
I've got thefollowing error meassage:
"Error opening socket. SQLSTATE=08S01"
I've tried it with COM.ibm.db2.jdbc.net.DB2Driver too, but it didn't work.

Any idea?

bye,
toni

0
iton
Asked:
iton
1 Solution
 
waynezhuCommented:
Port number 523 is used for db2 admin server.

For jdbc connection, try the default port 6789
or the port number specified when you start
the demon.

Make sure the java demon (db2jd) is running.
("ps -ef | grep db2jd" to check the process)

If not, start it using "db2jstrt" [default to port 6789]
or "db2jstrt port_number".
("netstat -na" can be used to check the port number)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now