364,036 Members | 5377 Browsing Online
Community for Developers & IT Professionals
Bytes IT Community

Help with "SQL30081N A communication error has been detected"

Laura
P: n/a
Laura
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
Share this Question
Share on Google+
3 Replies


Larry
P: n/a
Larry
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:[color=blue]
> 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!
>[/color]
Nov 12 '05 #2

Matt Emmerton
P: n/a
Matt Emmerton

"Laura" <lgm@tid.es> wrote in message
news:1121439148.518138.47370@g47g2000cwa.googlegro ups.com...[color=blue]
> 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![/color]

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

Laura
P: n/a
Laura
Sorry not responding before. The port number was wrong, the
installation was easy and perfect!. Thankyou very much.

Nov 12 '05 #4

Post your reply

Help answer this question



Didn't find the answer to your DB2 Database question?

You can also browse similar questions: DB2 Database