472,952 Members | 2,592 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,952 software developers and data experts.

how to set/configure ip for DB2 on windows for remote JDBC

Hi All

I'm new to set up DB2 though using JDBC for years.
my question is:

supposed there are 3 computers in local-net, named A,B,C (they are Windows
2000 families). DB2 installed in A (port is db2c_DB2 50000/tcp) which hosts
a web, named www.abc.com, using dynamic ip, like 1.2.3.4 for a week them
2.3.4.5 for another week
when using JDBC within local-net by using,
Class.forName("COM.ibm.db2.jdbc.net.DB2Driver");
Connection conn = DriverManager.getConnection("jdbc:db2://A/datainstance");
three of them work as expected; but if replace
"jdbc:db2://A/datainstance" with "jdbc:db2://www.abc.com/datainstance" or
"jdbc:db2://www.abc.com:50000/datainstance"
none of them works.
Error message were " CLI0616E Error opening socket" and "no suitable
driver" respectively.
Actually the router has been set port 50000 to point to A and opened to
public.

Can any one tell me how to fix it?

--
Thanks lots in advance

John Woo
Toronto
Nov 12 '05 #1
3 7814
The .net.DB2Driver does not communicate through port 50000. Check your
system running UDB and see what port db2jstrt (the JDBC server) is
using. I suspect that the //A/datainstance connection is automagically
determining the correct port for you where your specification of 50000
is incorrect.

The recommended default port for db2jstrt is 6789.

See Application Development Guide: Building and Running Applications
(db2axe80.pdf):
Chapter 4; JDBC; Building JDBC applets
for additional details

Phil Sherman

John wrote:
Hi All

I'm new to set up DB2 though using JDBC for years.
my question is:

supposed there are 3 computers in local-net, named A,B,C (they are Windows
2000 families). DB2 installed in A (port is db2c_DB2 50000/tcp) which hosts
a web, named www.abc.com, using dynamic ip, like 1.2.3.4 for a week them
2.3.4.5 for another week
when using JDBC within local-net by using,
Class.forName("COM.ibm.db2.jdbc.net.DB2Driver");
Connection conn = DriverManager.getConnection("jdbc:db2://A/datainstance");
three of them work as expected; but if replace
"jdbc:db2://A/datainstance" with "jdbc:db2://www.abc.com/datainstance" or
"jdbc:db2://www.abc.com:50000/datainstance"
none of them works.
Error message were " CLI0616E Error opening socket" and "no suitable
driver" respectively.
Actually the router has been set port 50000 to point to A and opened to
public.

Can any one tell me how to fix it?

--
Thanks lots in advance

John Woo
Toronto


Nov 12 '05 #2
"Philip Sherman" <ps******@ameritech.net> wrote in message
news:qf*******************@newssvr28.news.prodigy. com...
The .net.DB2Driver does not communicate through port 50000. Check your
system running UDB and see what port db2jstrt (the JDBC server) is
using. I suspect that the //A/datainstance connection is automagically
determining the correct port for you where your specification of 50000
is incorrect.

The recommended default port for db2jstrt is 6789.
Thanks lots Philip Sherman. YES, port for db2jstrt is 6789 is also for my
computer.
one more question, hope you won't mind asking:
when checking the net-ports statuc, I got from my windows, for db2
Proto Local Address Foreign Address State
TCP A:db2c_DB2 A:0
what's is the numeric port for this db2c_DB2? in some programs/editors,
we're supposed to input numbers.

--
Best Regards
John Woo
Toronto
See Application Development Guide: Building and Running Applications
(db2axe80.pdf):
Chapter 4; JDBC; Building JDBC applets
for additional details

Phil Sherman

John wrote:
Hi All

I'm new to set up DB2 though using JDBC for years.
my question is:

supposed there are 3 computers in local-net, named A,B,C (they are Windows 2000 families). DB2 installed in A (port is db2c_DB2 50000/tcp) which hosts a web, named www.abc.com, using dynamic ip, like 1.2.3.4 for a week them 2.3.4.5 for another week
when using JDBC within local-net by using,
Class.forName("COM.ibm.db2.jdbc.net.DB2Driver");
Connection conn = DriverManager.getConnection("jdbc:db2://A/datainstance"); three of them work as expected; but if replace
"jdbc:db2://A/datainstance" with "jdbc:db2://www.abc.com/datainstance" or "jdbc:db2://www.abc.com:50000/datainstance"
none of them works.
Error message were " CLI0616E Error opening socket" and "no suitable
driver" respectively.
Actually the router has been set port 50000 to point to A and opened to
public.

Can any one tell me how to fix it?

--
Thanks lots in advance

John Woo
Toronto

Nov 12 '05 #3
Ian
John wrote:
"Philip Sherman" <ps******@ameritech.net> wrote in message
news:qf*******************@newssvr28.news.prodigy. com...
The .net.DB2Driver does not communicate through port 50000. Check your
system running UDB and see what port db2jstrt (the JDBC server) is
using. I suspect that the //A/datainstance connection is automagically
determining the correct port for you where your specification of 50000
is incorrect.

The recommended default port for db2jstrt is 6789.


Thanks lots Philip Sherman. YES, port for db2jstrt is 6789 is also for my
computer.
one more question, hope you won't mind asking:
when checking the net-ports statuc, I got from my windows, for db2
Proto Local Address Foreign Address State
TCP A:db2c_DB2 A:0
what's is the numeric port for this db2c_DB2? in some programs/editors,
we're supposed to input numbers.


That's defined in the services file. /etc/services on unix, or
\WINDOWS\system32\drivers\etc\services on Windows.


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Darko Jovisic | last post by:
Hello! I'm quite new to Java. I'm making an MySQL interface. So my problem is: Can I connect to a remote mysql database without having any additional software running on that server ? Is JDBC...
0
by: Ref | last post by:
Hi I am new with Replication I develop Now the Microsoft Server 2000 Replication And I chose Snapshot type for replication All I need to copy Part of db from Publisher via distributor to...
4
by: banz | last post by:
Hello I have a problem to resolve: I wrote a Perlscript which caches data from a server (local on my machine) I would like to have a other connection to a remote server but I don't know how to...
1
by: Markus Wollny | last post by:
Hi! I am trying to build PostgreSQL 7.4.3 with Java enabled; I've got Apache Ant version 1.5 and j2sdk1.4.1_05 installed: Verifiying ant: # which javac /usr/java/j2sdk1.4.1_05/bin/javac #...
5
by: mjf | last post by:
I'd like to connect from any Linux machine to the DB2 on a Linux server via an IP adddress (or any available method that allows us to connect to DB2 from another machine). I know we can do it in...
7
by: Ike | last post by:
Let's say I have a MySQL 4.12 database, opened to the internet on 111.111.111.111 allowing all incoming and outgoing ports. I have a username and password setup, which CAN connect to this database,...
4
by: tommaso.gastaldi | last post by:
If one does not configure a virtual dir as an IIS application, he/she receives the common error: ---------------------------------------- Server Error in '/' Application. .... This error can be...
13
by: Josť Joye | last post by:
Hello, What is the best way to stop a remoting server (Singleton SAO) that has been started with RemotingConfiguration.Configure(). For sure, I want to do this without quitting the application...
1
by: sandeepkumarbhati | last post by:
hi i want to configure jdbc sql driver in netbeans if you have any idea then please reply me please explain in detail(step by step) thank you.
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.