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