db2 - jdbc problem

Posted on 2002-04-24
Medium Priority
Last Modified: 2011-04-14
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:
But, if I set the URL on the following way:
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?


Question by:iton
1 Comment

Accepted Solution

waynezhu earned 880 total points
ID: 6966434
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)

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

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

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…
Through the video, you can check the migration process of Outlook PST file to PDF. Kernel for Outlook to PDF tool can convert Outlook emails with all attributes like Subject, To, From, Cc, Bcc and other folders such as Inbox, Outbox, Sent Items, Jun…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question