Hi,

Im using the Config assistant to connect a client to a remote server, when finished i get the error below, any ideas?

I have run the 'CATALOG' cmds on the client e.g.

db2 catalog tcpip node db2 remote 9.162.141.153 server 22
db2 catalog database DBNAME as DBNAME at node db2
db2 CATALOG DCS DATABASE DBNAME

and can see the port is listening in netstat -a | more e.g.
tcp 0 0 *:xcmccarth *:* LISTEN

I haven't configured anything on the server side as dont have permissions, do I need to? but in the /etc/services file i can see the remote connection port is 446 which is the same as i config on the client,

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

Thanks

When you catalog the node on the client workstation, you need to supply the port for the DB2 instance on the server. This normally defaults to 50000. Run "db2 get dbm cfg" on the server as the instance an look for SVCENAME. This will either be the port name or the name in /etc/services.

Andy

Hi ARwinner,

thanks for the reply,

the actual catalog cmd used was

db2 catalog tcpip node UNIX remote 9.162.141.153 server 446

which ssigned the PORT = 446

and from the db2 get dbm cfg
TCP/IP Service name (SVCENAME) = xcmccarth
which is on port 446

and can see the port is listening in netstat -a | more e.g.
tcp 0 0 *:xcmccarth *:* LISTEN


and from the /ect/services file

ddm-rdb 446/tcp # DDM-Remote Relational Database Access
ddm-rdb 446/udp # DDM-Remote Relational Database Access


it all looks okay eh?
but the connect on the server fails

What is the output of this command on the server:

cat /etc/services | grep -i xcmccarth

Andy

db2dev03 /etc> cat /etc/services | grep -i xcmccarth
db2dev03 /etc>

nothing returned...

but in the configuration assistant on step two..

Specify TCP/IP communication parameters

Hostname: 9.162.141.155
Sevice name: xcmccarth

the retrieve button finds the entry 'xcmccarth' and returns 446 for the port number, Is this from the services file?

I tend not to use the configuration assistant mainly because it supplies the node name as something totally non-meaningful.

Supplying the SVCENAME instead of the port number, I believe will have the system look into the /etc/services file for the port of the name specified. In your case, it does not exist.

Andy

446 is a port used by DB2 Connect for mainframe connection