472,352 Members | 1,522 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

Attempting to connect with client to remote DB2 instance

Hi,

I installed the admin client on my WebSphere box. I am now attempting
to connect to my DB2 server (on another box). I have been able to find
the DB2 server, instance and needed databases. These auto-register
themselves in the admin client. However, when I try to connect to the
db's to look at the Table details I get the following errors:

-------
[IBM][CLI Driver] SQL30081N A communication error has
been
detected. Communication protocol being used:
"TCP/IP".
Communication API being used: "SOCKETS". Location
where the
error was detected: "9.9.45.110". Communication
function
detecting the error: "connect". Protocol specific
error
code(s): "111", "*", "*". SQLSTATE=08001
--------

Also, this is the command that is being sent:

UNCATALOG NODE DB2;
CATALOG TCPIP NODE DB2 REMOTE eb13.atlanta.ibm.com
SERVER db2 SECURITY SOCKS REMOTE_INSTANCE db2 SYSTEM
DYN9009045110 OSTYPE LINUX;
Is there anything I'm missing?

Thanks,

Nov 12 '05 #1
3 7070
Need your platforms. But if you check the DB2 communication error codes,
"111" seems to be Connection Refused on Linux. "The connection has been
refused. If you are trying to connect to the database, check that the
database manager and TCP/IP protocol support at the server have been
started successfully. If using SOCKS protocol support, also ensure that
TCP/IP protocol support at the SOCKS server has been started successfully"

See

http://publib.boulder.ibm.com/infoce...e/rcommsec.htm

Larry Edelstein

Harlin wrote:
Hi,

I installed the admin client on my WebSphere box. I am now attempting
to connect to my DB2 server (on another box). I have been able to find
the DB2 server, instance and needed databases. These auto-register
themselves in the admin client. However, when I try to connect to the
db's to look at the Table details I get the following errors:

-------
[IBM][CLI Driver] SQL30081N A communication error has
been
detected. Communication protocol being used:
"TCP/IP".
Communication API being used: "SOCKETS". Location
where the
error was detected: "9.9.45.110". Communication
function
detecting the error: "connect". Protocol specific
error
code(s): "111", "*", "*". SQLSTATE=08001
--------

Also, this is the command that is being sent:

UNCATALOG NODE DB2;
CATALOG TCPIP NODE DB2 REMOTE eb13.atlanta.ibm.com
SERVER db2 SECURITY SOCKS REMOTE_INSTANCE db2 SYSTEM
DYN9009045110 OSTYPE LINUX;
Is there anything I'm missing?

Thanks,

Nov 12 '05 #2
Hi Larry,

These are both running Suse 9 Enterprise with DB2 8.1 -- actually the
DB2 server was running on RedHat 4 Ent. but it will be changing to Suse
9 today some time (11/1/2005). We will try this again later in the day.
Thanks very much for the help!

Harlin Seritt

Nov 12 '05 #3
Ian
Harlin wrote:
Also, this is the command that is being sent:

UNCATALOG NODE DB2;
CATALOG TCPIP NODE DB2 REMOTE eb13.atlanta.ibm.com
SERVER db2 SECURITY SOCKS REMOTE_INSTANCE db2 SYSTEM
DYN9009045110 OSTYPE LINUX;

Make sure that 'db2' is defined in /etc/services on the client machine
and matches the port number that the DB2 server is listening on.
Nov 12 '05 #4

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

Similar topics

4
by: Scott Holland | last post by:
HELP - Need to connect to DB2 database on AIX from NT server. Also AS/400 from NT Server -- I am experienced in ORACLE and a novice at DB2. ...
3
by: Fabian Knopf | last post by:
Hi friends, i have a unix machine PC1 where a database is running ( IBM DB2 V8.1 ) . Then i have another machine PC2 i installed there also ( IBM...
5
by: mayamorning123 | last post by:
A comparison among six VSS remote tools including SourceOffSite , SourceAnyWhere, VSS Connect, SourceXT, VSS Remoting, VSS.NET To view the full...
22
by: Kristof Thys | last post by:
Hello, I'm developing a C# - windows forms application. To get some information for my application, I'm connecting to an URL, wich gives me XML...
14
by: DaTurk | last post by:
I am makeing a Multicast server client setup and was wondering what the difference is between Socket.Connect, and Socket.Bind. It may be a stupid...
14
by: Marcus | last post by:
I have a function that simply returns TRUE if it can connect to a particular Sql Server 2005 express, or FALSE if it cannot. I am getting some...
11
by: Mikael Arhelger | last post by:
Hello, This has been posted a few times but still I could not find a way to connect to our database. We run DB2 Express on WIN2K server with XP...
0
by: tamayi | last post by:
I have a problem (like most others posting issues on this forum :) ) I have a remote server running Windows XP SP2, with both SQL Server 2005...
1
Shashi Sadasivan
by: Shashi Sadasivan | last post by:
Hi, After some search around, trying to get my SQL Management studio (running on Vista) to connect to a remote SQL server instance, i finally nailed...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....

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.