473,320 Members | 1,902 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 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 7834
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: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

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.