SQL30081N - Protocol specific error code(s): "10055", "*", "*". SQLSTATE=08001

When I try connect to a cataloged DB I get this error:

QL30081N  A communication error has been detected.  Communication protocol
being used: "TCP/IP".  Communication API being used: "SOCKETS".  Location
where the error was detected: "SERVER IP".  Communication function
detecting the error: "connect".  Protocol specific error code(s): "10055", "*",
"*".  SQLSTATE=08001

The database resides on AIX server. I have cataloged it on a windows server.
jsaravanaAsked:
Who is Participating?
 
momi_sabagCommented:
the most simple approach to check:
using ip addr + port number, try this from your station:
start->run->cmd.exe

telnet ip-addr port

if you can't use telnet, then your ports are probably blocked
you can also try to connect and in the same time run
start->run->cmd.exe

netstat -an

if you see that your connect attemp (you can find it by the ip and port of the db2 serveR) has status SYN_SENT
it mean you have some kind of firewall blcok
0
 
momi_sabagCommented:
were you able to connect to it in the past or is this a new database?

did you check that the instance is up and running?
did you check that your firewall does not block the ports used by DB2 ?
0
 
jsaravanaAuthor Commented:
This is the first time we are cataloging this database.

The instance is up n running.

I am not sure if any firewall is blocking the connection
0
 
jsaravanaAuthor Commented:
Thanks..

Now I am able to connect, I had some tablespace issue in other database which was requesting for backup.
When I took offline backup and tried connecting I was able to connect.

Those were found in system error logs.

I will try and find out you suggestions as well. Will be useful for me.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.