Hi,
I have a remote server.. From client machine did catalog tcip and catalog database on the remote databse. I am unable to do a test connection from client.
Getting the following error, tried all options but couldn't get it working. Greatly appreciate your assistance
SQL30081N A communication error has been detected. Communication protocol
being used: "TCP/IP". Communication API being used: "SOCKETS". Location
where the error was detected: "DB2 server IP". Communication function
detecting the error: "connect". Protocol specific error code(s): "10060", "*",
"*". SQLSTATE=08001
Regards,
Srini
1 8059
The specific return code listed in this
error output is a 10061, which is the tcp/ip error ECONNREFUSED. "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 has been started successfully".
Typically this particular error message occurs under one of the
following scenarios:
1. The instance is not running. Issue a db2start to confirm that the
instance is online and try the connection again.
2. The instance on the remote server has not been configured to accept
TCP/IP communication requests. On the server, please verify the
following:
a. Issue a db2set -all and confirm that the parameter DB2COMM=TCPIP.
If this is not set, issue:
db2set DB2COMM=TCPIP
b. Issue the command "db2 get dbm cfg | grep SVCENAME" and confirm that
this parameter is not blank. This may either specify a service name
defined in your /etc/services file, or a port number, but this value
must be set. If this is blank, please update the dbm cfg using:
db2 update dbm cfg using SVCENAME 50000
db2stop
db2start
Once the instance has been restarted, verify that the TCP/IP port is
listening with the command:
netstat -an | grep 50000
This should return output similar to the following:
tcp4 0 0 *.50000 *.*
LISTEN
Also note that if the SVCENAME parameter specifies a service name rather
than a port number, this service name must be defined in /etc/services.
3. The catalog on the client has specified the wrong port number. On
the client, please issue the command "db2 list node directory" and
locate the entry for the system in question. Please verify that the
port number listed here under the Service name field matches that of the
port number specified in the SVCENAME parameter on the server. As on
the server, if the service name specifies a name rather than a port,
this must exist by the same name (case sensitive) in the /etc/services
file on Unix, or in the C:\Windows\Syst em32\drivers\et c\services file on
Windows.
4. The catalog on the client may have the wrong host name specified, or
a correct host name that can not be identified by the network. Please
check the Hostname parameter in the "db2 list node directory" from item
3 above, and confirm if this target can be reached using the ping
command:
ping <hostname>
If the ping is successful, your network should be configured correctly
to reach this machine. If the ping failed, please verify that the
/etc/hosts file on the client (if Unix) or the
C:\Windows\syst em32\drivers\et c\hosts file (on Windows) has an IP
address specified for this host name. Alternately, you may catalog the
connection directly specifying the IP address.
5. If the client and the server are on opposite sides of a firewall,
please ensure that your firewall or router are not configured to block
communication on the port specified for the SVCENAME parameter on the
server.
Thank you, Shashank K. Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Angel Todorov |
last post by:
Hello,
I am currently adding SSL support to the Npgsql driver (the .NET data
provider for PostgreSQL). I have tested with the Mentalis Secure Library
(http://www.mentalis.org/soft/projects/ssocket/). I am creating the
SecureTcpSocket as an instance that uses Ssl version 3.0. The PostgreSQL
server is configured as described in
http://developer.postgresql.org/docs/postgres/ssl-tcp.html . SSL support
is added in pg_hba.conf, via hostssl
The...
|
by: alederer |
last post by:
Hallo!
I have the following situation:
A db2 v6.1 client on AIX 4.3 (db2level reports U469703) and a OS/390
database version 6.1 .
In some situations, I get the following error in my db2 CLI application:
SQL30081N A communication error has been
|
by: xixi |
last post by:
i have catalog a remote database on my local db2 server, but now the
remote database server with same machine name but the ip address
changed, so i remove the old one, and try to catalog again under
control center --- all cataloged systems, then i use discover search
button, find the sysetm name, but gives me error
SQL30081N A communication error has been detected. Communication
protocol being used: "TCP/IP". Communication API being...
|
by: Tim Reynolds |
last post by:
I support a .Net application running on a SERVER accessing MF Db2
data. Occasionally, we have some type of connection problem that we
have been unable to debug up to this point. We typically receive one
of these IBM.Data.DB2.DB2Exception messages:
ERROR SQL30081N A communication error has
been detected. Communication protocol being used: ‘TCP/IP'.
Communication API being used: ‘SOCKETS'. Location where the error was
detected:...
|
by: Laura |
last post by:
I've just installed the DB2 Run-time client in a Solaris machine. Then
I finnish the installation configuring the connection:
1. machine catalog was OK:
==========================
$ db2 catalog tcpip node atlas remote dsroracle server 8100
DB20000I The CATALOG TCPIP NODE command completed successfully.
DB21056W Directory changes may not be effective until the directory
cache is refreshed.
2. database catalog was OK:
| |
by: Praveen |
last post by:
Hi,
I have installed WebSphere Portal on AIX and connected to DB2 on a
remote machine, Getting the followin errors when trying to get the
values from database thru applications installed on Portal.
Any Help Appreciated.
Thanks in advance.
Praveen Singh
|
by: Ralf Gross |
last post by:
Hi,
I installed DB2 V8.1 with fixpak 10, created a new database and can
connect to the database.
$ db2 connect to mkstest
Database Connection Information
Database server = DB2/LINUX 8.2.3
|
by: anithak |
last post by:
How to fix this error
"A communication error has been occurred. Communication protocol being used:"TCP/IP". Communcation API being used: "SOCKETS". Location where the error was detected: "
|
by: xoise |
last post by:
Warning: mysql_connect() : Lost connection to MySQL server at 'reading initial communication packet', system error: 113 in /webs/sites/monetized.com/includes/mysql_connect.inc.php on line 2
Lost connection to MySQL server at 'reading initial communication packet', system error: 113
I'm receiving the above error whenever trying to connect to my database server from any remote server. It WAS working before without any problems. I can't think...
|
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: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: 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...
| |