473,375 Members | 1,567 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,375 software developers and data experts.

SQL30081N A communication error has been detected

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
SQL authorization ID = DB2INST1
Local database alias = MKSTEST
After that I wanted to connect to the database by tcpip (client & server
is the same host!).

$ db2 catalog tcpip node mksdb remote $myIP server 50000
$ db2 catalog database mkstest as mkstcp at node mksdb
$ db2 LIST NODE DIRECTORY

Node Directory

Number of entries in the directory = 1

Node 1 entry:

Node name = MKSDB
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = $myIP
Service name = 5000

$ db2 LIST DATABASE DIRECTORY

System Database Directory

Number of entries in the directory = 3

Database 1 entry:

Database alias = TOOLSDB
Database name = TOOLSDB
Local database directory = /home/db2inst1
Database release level = a.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =

Database 2 entry:

Database alias = MKSTCP
Database name = MKSTEST
Node name = MKSDB
Database release level = a.00
Comment =
Directory entry type = Remote
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =

Database 3 entry:

Database alias = MKSTEST
Database name = MKSTEST
Local database directory = /home/db2inst1
Database release level = a.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =

Now the connection to the db using tcpip fails.

$ db2 connect to mkstcp
SQL30081N A communication error has been detected. Communication protocol
being used: "TCP/IP". Communication API being used: "SOCKETS". Location
where the error was detected: "$myIP". Communication function
detecting the error: "connect". Protocol specific error code(s): "111", "*",
"*". SQLSTATE=08001
The service is listening on port 5000
tcp 0 0 0.0.0.0:50000 0.0.0.0:* LISTEN 25797/db2tcpcm 0
Any idea what might be the problem?

Ralf

Nov 12 '05 #1
4 35995
Ian
Ralf Gross wrote:
$ db2 catalog tcpip node mksdb remote $myIP server 50000
$ db2 catalog database mkstest as mkstcp at node mksdb
$ db2 LIST NODE DIRECTORY

Node Directory

Number of entries in the directory = 1

Node 1 entry:

Node name = MKSDB
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = $myIP
Service name = 5000

[...]

Now the connection to the db using tcpip fails.

$ db2 connect to mkstcp
SQL30081N A communication error has been detected. Communication protocol
being used: "TCP/IP". Communication API being used: "SOCKETS". Location
where the error was detected: "$myIP". Communication function
detecting the error: "connect". Protocol specific error code(s): "111", "*",
"*". SQLSTATE=08001
The service is listening on port 5000
tcp 0 0 0.0.0.0:50000 0.0.0.0:* LISTEN 25797/db2tcpcm 0


That looks like port 50000, not 5000. Looks like your node directory
shows port 5000, but you say your database is listening on port 50000.

Nov 12 '05 #2
Ralf Gross wrote:
detecting the error: "connect". Protocol specific error code(s): "111", "*",


111 = ECONNREFUSED (on Linux)

I know I had similar problems under OS/2 some years ago...

Try "db2stop force" and "db2admin stop"

Then "db2admin start" - it should start without any error message. If
not, try "db2admin drop" and then "db2admin.exe CREATE /USER:benutzer
/PASSWORD:kennwort" (user and password should be the user/password used
during installation of DB2 or a user with enough right - no idea which
rights are needed under Linux).

Don't forget "db2start" at the end to start the database manager

Bernd

--
"Ja, alles meine Herren" sprach Fürst Lichnowsky. "Ooch det roochen?"
"Ja, auch das Rauchen." "Ooch im Tiergarten?" "Ja, auch im Tiergarten
darf geraucht werden, meine Herren." Und so endeten die Barrikadenkämpfe
des 18. März in Berlin
Nov 12 '05 #3
Ian wrote:
Ralf Gross wrote:
The service is listening on port 5000
tcp 0 0 0.0.0.0:50000 0.0.0.0:* LISTEN 25797/db2tcpcm 0


That looks like port 50000, not 5000. Looks like your node directory
shows port 5000, but you say your database is listening on port 50000.


You are right, I used the wrong port. cut&paste at it's best...

Thanks, Ralf
Nov 12 '05 #4
Bernd Hohmann wrote:
Ralf Gross wrote:
[db2 tcpip connection fails]


I just used the wrong port for the connection, 5000 instead of 50000...

Ralf
Nov 12 '05 #5

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

Similar topics

1
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...
3
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...
2
by: WantedToBeDBA | last post by:
Hi all, We have db2 installed on AIX box (db2 version - 8.1). Its started and i am able to view 50000(default port) in netstat(netstat -a -n). But when i try to connect using telnet, i am getting...
3
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...
1
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...
4
by: Asphalt Blazer | last post by:
Hi, I have a remote DB2 database on AIX and I am accessing ti using a windows client .i was using control center on windows to add the remote system under it and I gave all the node names and...
0
by: Troels Arvin | last post by:
Hello, From SAS, we're getting the following error message once in a while: ERROR: CLI error trying to establish connection: SQL30081N A communication error has been detected. Communication...
2
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: "
1
by: toffees | last post by:
Hi, I am having some problems getting an application server to connect to the database server. Both servers run on Windows 2000 Server. DB2 version 7.2 is running on the database server. I am able...
1
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: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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 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.