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, 3 7182
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,
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.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. 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...
|
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...
|
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...
|
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...
|
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...
| |
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...
|
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...
|
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...
|
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...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
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...
|
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...
|
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 ...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |