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

Help with "SQL30081N A communication error has been detected"

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:
===========================
$ db2 catalog db ATPAMIC at node atlas
DB20000I The CATALOG DATABASE command completed successfully.
DB21056W Directory changes may not be effective until the directory
cache is refreshed.
3. Y executed a "db2 terminate"
===============================
4. And then tried to connect but I always get the same error:
================================================== ===========
$ db2 connect to ATPAMIC user a9odsp using a9odsp
SQL30081N A communication error has been detected. Communication
protocol
being used: "TCP/IP". Communication API being used: "SOCKETS".
Location
where the error was detected: "10.33.241.42". Communication function
detecting the error: "connect". Protocol specific error code(s):
"146", "*",
"*". SQLSTATE=08001

Any idea about how to fix this error?
Thank you very much!

Nov 12 '05 #1
3 6992
Are you trying to connect to an Oracle database from a DB2 Run-time
Client? If so, this cannot be done. You need Websphere Information
Integrator.

Larry Edelstein

Laura wrote:
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:
===========================
$ db2 catalog db ATPAMIC at node atlas
DB20000I The CATALOG DATABASE command completed successfully.
DB21056W Directory changes may not be effective until the directory
cache is refreshed.
3. Y executed a "db2 terminate"
===============================
4. And then tried to connect but I always get the same error:
================================================== ===========
$ db2 connect to ATPAMIC user a9odsp using a9odsp
SQL30081N A communication error has been detected. Communication
protocol
being used: "TCP/IP". Communication API being used: "SOCKETS".
Location
where the error was detected: "10.33.241.42". Communication function
detecting the error: "connect". Protocol specific error code(s):
"146", "*",
"*". SQLSTATE=08001

Any idea about how to fix this error?
Thank you very much!

Nov 12 '05 #2

"Laura" <lg*@tid.es> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...
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:
===========================
$ db2 catalog db ATPAMIC at node atlas
DB20000I The CATALOG DATABASE command completed successfully.
DB21056W Directory changes may not be effective until the directory
cache is refreshed.
3. Y executed a "db2 terminate"
===============================
4. And then tried to connect but I always get the same error:
================================================== ===========
$ db2 connect to ATPAMIC user a9odsp using a9odsp
SQL30081N A communication error has been detected. Communication
protocol
being used: "TCP/IP". Communication API being used: "SOCKETS".
Location
where the error was detected: "10.33.241.42". Communication function
detecting the error: "connect". Protocol specific error code(s):
"146", "*",
"*". SQLSTATE=08001

Any idea about how to fix this error?
Thank you very much!


Error 146 is ECONNREFUSED (connection refused) on Solaris.

Is DB2 started on the server?
Do you have DB2CONN=tcpip set on the server?
Is DB2 listening on port 8100? (It normally listens on port 50000).

Or are you trying to connect to an Oracle database :)

--
Matt Emmerton
Nov 12 '05 #3
Sorry not responding before. The port number was wrong, the
installation was easy and perfect!. Thankyou very much.

Nov 12 '05 #4

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

Similar topics

6
by: Matt Bostock | last post by:
Hi, When I validate this page: http://www.drfunkenstein.net/using http://jigsaw.w3.org/css-validator/, I get the following results: ...
3
by: N. Graves | last post by:
Hello, I don't understand this error message." Error accessing File. Network Connection may have been lost." I'm not using any network connection for the database. In the VBA editor is goes...
0
by: Martin Colmenares | last post by:
After I set my <%@ page ValidateRequest="false" %> , I still get the error illustrated below. The msdn mentioned something about filtering using the HTMLEncode. This is a snippet of the code that...
3
by: ebj | last post by:
I get this error message from time to time in my new app: "CallbackOnCollectedDelegate was detected Message: A callback was made on a garbage collected delegate of type...
16
by: Steve Chapel | last post by:
When I load the page <https://bugzilla.mozilla.org/attachment.cgi?id=237739with Internet Explorer 7 RC 1, I get the error "Object Expected" at line 174. When I click on the button, I also get the...
3
by: JToe | last post by:
Hi, I have a sql statement which is as follows:- INSERT INTO expense(Jan) SELECT sum(ECFAmount) FROM Transaction WHERE Date BETWEEN (#01/01/2007#) AND (#01/31/2007# ) When i execute the...
18
by: ana10192000 | last post by:
VB6.0 Private dbParts as Database Private dbParts as Recordset guys help, i can't execute my program compiler error says: " user-defined type not defined " i'm not much a knowledgable...
3
by: Renzr | last post by:
I have a C++ package which works very well in the 32-bit Linux-like OS. However, it will lead to a "*** glibc detected *** ./ex2: munmap_chunk(): invalid pointer" in 64-bit (Fedora 7-64), when it...
1
by: itxharsh | last post by:
/* While running the program a runtime error occurs."glibc detected" followed by a lot of memory address/instruction errors. Please help rectify this error.*/ /*Header file:"nonpreemptive.h" is as...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.