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.ib m.com
SERVER db2 SECURITY SOCKS REMOTE_INSTANCE db2 SYSTEM
DYN9009045110 OSTYPE LINUX;
Is there anything I'm missing?
Thanks,
3  7230 
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.ib m.com
SERVER db2 SECURITY SOCKS REMOTE_INSTANCE db2 SYSTEM
DYN9009045110 OSTYPE LINUX;
Is there anything I'm missing?
Thanks,
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
Harlin wrote: Also, this is the command that is being sent:
UNCATALOG NODE DB2;
CATALOG TCPIP NODE DB2 REMOTE eb13.atlanta.ib m.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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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. What tools would
be the equivalent of Net*8 or SQLNET in ORACLE that would allow me to
connect to a database on a remote box (either AIX or AS/400)? I have
read that DB2 Connect appears to be the ticket for the Db2 server if
it is on AS/400 or OS/390. What if it is on AIX? Does the same tool...
|
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 DB2 V8.1 ). On
PC2 i installed unixODBC. To connect to the database over ODBC on unix i did
this:
on db2 console:
catalog tcpip node archiv remote PC1 server DB2_db2inst1
|
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 article, please visit
http://www.BetterVssRemoting.com
Better VSS Remote Access Tool
This article makes a detailed comparison among SourceAnyWhere 4.0,
SourceOffSite 4.1, VSS Connect 1.5, SourceXT 2.1, VSS Remoting 2.5,
|
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
generated using php.
With 90% of the users, this code just works fine:
WebRequest request = WebRequest.Create(URL);
|
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 question, but I was just curious. Because I tried a
test, and I can't bind two sockets to the same port/ip but I can
connect with one socket, and bind with another to the same ip/port.
Thanks
| | |
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 strange error codes returned when the computer that sql server
resides on is not reachable. The error is different depending on the
connection string that I use. If I use the following connection string:
"server=192.1.1.1; Initial Catalog=master; uid=The_User;
password=The_Password; Connect...
|
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
clients. I can ping inside network and to the Internet from the
server, so TCP/IP is ok. The DB2COMM=TCPIP is set also.
Have been scratching my head for days now.
Here some additional data (we are running SAP Business One):
|
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 Express with Advanced Features and SQL 2000 installed. I can
remotely connect to the SQL Server 2000 instance using Query Analyser
or Enterprise Manager. I can also remotely connect to the SQLEXPRESS
using Management Studio Express Edition.
I am writing an ASP.NET 2.0 with VS2005 application...
|
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 it.
Your management studio will refuse to connect onto the remote instances of SQL sever... One of the easiest way around this is to disable your firewall and then connect usually.
Well...this isint really a very good idea, and will drive you nuts atleast 2-5 times a day.
To overcome this...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
